Skip site navigation (1) Skip section navigation (2)

Re: How do I select the last Id in a column???

From: Ericson Smith <eric(at)did-it(dot)com>
To: Josh Goldberg <josh(at)4dmatrix(dot)com>
Cc: Michael Kovalcik <makd32(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: How do I select the last Id in a column???
Date: 2003-06-26 21:10:04
Message-ID: 3EFB612C.50800@did-it.com (view raw or flat)
Thread:
Lists: pgsql-admin
To get the ID after the fact:
   SELECT currval('my_seq') AS id;

To get the ID before even inserting it
   SELECT nextval('my_seq') AS id;


- Ericson Smith
eric(at)did-it(dot)com


Josh Goldberg wrote:

>to get the last record inserted just
>select * from row order by autoincId desc limit 1;
>
>if you have several clients doing this you might want to put your insert and
>the select inside a transaction.
>
>----- Original Message -----
>From: "Michael Kovalcik" <makd32(at)yahoo(dot)com>
>To: <pgsql-admin(at)postgresql(dot)org>
>Sent: Monday, June 23, 2003 11:47 AM
>Subject: [ADMIN] How do I select the last Id in a column???
>
>
>  
>
>>Hello,
>>
>>I'm trying to find out how I select the last id in a
>>column if I don't know anything else about the row.
>>What i am doing is inserting information into my
>>Orders table and the id is auto-incrementing.  The
>>next thing i want to be able to do is grab the the id
>>of the order i just inserted.  How do i do this?
>>
>>Here is the code i have so far:
>>
>>my $sql = "INSERT INTO ${Orders}
>>(locationid,shippingid,statusid,date) VALUES (?
>>,?,?,?)";
>>
>>my $sth = $dbh->prepare($sql);
>>
>>$sth->execute(${LocationID},${ShippingID},${StatusID},${date});
>>#--*************************************
>>my $sth = $dbh->prepare("SELECT id FROM ${Orders}");
>>
>>$sth->execute();
>>$OrderID = $sth->fetchrow_arrayref;
>>
>>I know the select statement that i have will not work,
>>because it will bring me every id number in the table.
>> I just want the latest one.....
>>
>>Please HELP............
>>
>>Thank you so much,
>>Mike
>>
>>__________________________________
>>Do you Yahoo!?
>>SBC Yahoo! DSL - Now only $29.95 per month!
>>http://sbc.yahoo.com
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>>    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>>
>>    
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>  
>


In response to

pgsql-admin by date

Next:From: scott.marloweDate: 2003-06-26 21:13:18
Subject: Re: How do I select the last Id in a column???
Previous:From: Josh GoldbergDate: 2003-06-26 21:00:33
Subject: Re: How do I select the last Id in a column???

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group