Horton

Re: [Q] Sequences, last_value and inserts

Douglas McNaught <doug@mcnaught.org>

View thread View on postgr.es
From: Doug McNaught <doug@mcnaught.org>
To: "Roderick A. Anderson" <raanders@acm.org>
Cc: Bruno Wolff III <bruno@wolff.to>, <pgsql-general@postgresql.org>
Date: 2002-11-01T20:22:43Z
Lists: pgsql-general 
"Roderick A. Anderson" <raanders@acm.org> writes:

> On Fri, 1 Nov 2002, Bruno Wolff III wrote:
> 
> > You want to use currval. This can be used within a single session safely.
> 
> I must be thick today.
> 
> select currval from domain_info_tbl_key_seq;
> ERROR:  Attribute 'currval' not found

Try:

select currval('domain_info_tbl_key_seq');

If you read the docs, you would know this.  ;)

-Doug