From: Richard Huxton <dev@archonet.com>
To: ow <oneway_111@yahoo.com>, pgsql-sql@postgresql.org
Subject: Re: currval() without specifying the sequence name
Date: Tue, 9 Mar 2004 15:14:56 +0000
User-Agent: KMail/1.5
References: <20040309135021.57085.qmail@web60808.mail.yahoo.com>
In-Reply-To: <20040309135021.57085.qmail@web60808.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200403091514.56649.dev@archonet.com>

On Tuesday 09 March 2004 13:50, ow wrote:
> Hi,
>
> Is there a way to retrieve the current value (i.e. the last used value) of
> the last used sequence without specifying the sequence name? Something like
> the following:
>
> create table ( id serial, value varchar(10));
> insert into someOthertest (value) values ('100');
> insert into test (value) values ('10');
> insert into test (value) values ('20');
>
> select currval() should returns 2 (the last value of the test table
> sequence)

Not really - what if two sequences had been used?

-- 
  Richard Huxton
  Archonet Ltd