Re: getting currval from a sequence - BUG ?

Hi,
select currval('sequence_name');
with quotes should help you. But my pg 7.1.2 throws error
"sequence_name.currval is not yet defined in this session" (possibly bug
?). If I use sequence before calling this (for instance "insert into
mytable values(nextval('sequence_name'));" ), all is OK.

pajout

Bruno Wolff III wrote:

> On Mon, Feb 11, 2002 at 11:42:31AM +0100,
> tony <tony(at)animaproductions(dot)com> wrote:
>
>>How does one get the last record from a series of records? I just need
>>the id field which is a sequence field
>>
>
> select max(id) from whatever;
> (This assumes the sequence hasn't rolled over.)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>