Message-ID: <20031115205403.54792.qmail@web41007.mail.yahoo.com>
Date: Sat, 15 Nov 2003 12:54:03 -0800 (PST)
From: Theodore Petrosky <tedpet5@yahoo.com>
Subject: Re: Getting last insert value
To: Yasir Malik <ymalik@cs.stevens-tech.edu>,
	pgsql-sql@postgresql.org
In-Reply-To: <Pine.SGI.4.58.0311151003320.76056@guinness.cs.stevens-tech.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii


what does that mean the 'last row'? if client 1
inserts then client 2, the last row is client 2. do
you want to know what row client 1 inserted?
Personally I think your question is too broad. What
are you trying to accomplish?

Ted

--- Yasir Malik <ymalik@cs.stevens-tech.edu> wrote:
> Hello,
> I have a table with many fields, and one of the
> fields is of type serial.
> I will do many inserts, and there will be many
> repeats of the other fields
> in the table, but, obviously, the serial field will
> be unique for all the
> rows.  How can I get the value of serial field of
> the last row I inserted.
> I know I can select the maximum value from the
> serial field, but is there
> a better way, preferably something that takes
> constant time.
> Thanks,
> Yasir Malik
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree