Page 1 of 1

Getting inserted row

Posted: Fri Apr 02, 2004 4:00 am
by major
Is there any way to get the values I just inserted ?

ok like this it seems crazy but Im using a sequence Number (SERIAL) for Primary Key.
So when I insert a new row I dont know what will be the number.

So can I get that number or I need to do an query before getting the maximum value before the insert and increment that number by 1 (i find this way kind a wierd)

BTW Im using postgresql

Major

Posted: Fri Apr 02, 2004 1:24 pm
by lostboy