On Tuesday 21 October 2003 13:10, Jeff wrote:
> On Mon, 20 Oct 2003 21:52:17 -0700 (PDT)
>
> CSN <cool_screen_name90001@yahoo.com> wrote:
> > How do you get the last value of a sequence without
> > having called nextval? phppgadmin displays last value
> > for sequences (I haven't found out how yet rooting
> > through the code).
> >
> > CSN
>
> select curval('my_sequence')
Only works if you've called nextval() first.
I'm guessing phppgadmin uses SELECT * FROM my_seq_name
What were you planning to use this value for?
--
Richard Huxton
Archonet Ltd