Re: [Q] Sequences, last_value and inserts

select last_value from domain_info_tbl_key_seq;

This returns the same value as currval.

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Doug McNaught
> Sent: Friday, November 01, 2002 2:23 PM
> To: Roderick A. Anderson
> Cc: Bruno Wolff III; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] [Q] Sequences, last_value and inserts
>
>
> "Roderick A. Anderson" <raanders(at)acm(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>