Re: [GENERAL] getting the currval of a sequence - Mailing list pgsql-general

dustin sallings wrote:
>
> On Fri, 14 Aug 1998, Fran Fabrizio wrote:
>
>         If you've recently done an insert and want to know what the value
> was, you can do this:
>
>         select last_value from mysequence;

NO! This is wrong!

Use currval('_seq_name_') !!!

>
> //
> // Hi all,
> //
> // I need to do the equivalent of:
> //
> //  select my_sequence.CURRVAL from Sys.dual;
> //
> // so I'm guessing its:
> //
> //  select currvar('my_sequence') from ???????;
> //
> // Can anyone fill in the ????  Thanks!
> //

Vadim