Nice idea but how can I use this in a frontend that I am developing using Delphi and ADO objects ?
On Fri, Apr 11, 2008 at 7:41 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Fri, Apr 11, 2008 at 11:23 AM, Nacef LABIDI <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I was wondering if postgres can return the last ID inserted for a table > > which the primary key is autoincremented. I need to retrieve this ID in > my > > code to continue processing on that inserted row. > > smarlowe=# create table test (a serial primary key, b text); > NOTICE: CREATE TABLE will create implicit sequence "test_a_seq" for > serial column "test.a" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "test_pkey" for table "test" > CREATE TABLE > smarlowe=# insert into test (a,b) values (DEFAULT,'test') returning a; > a > --- > 1 > (1 row) > > INSERT 0 1 > > Note that there are other ways of doing it, but I really like the > returning clause. >
