Re: [HACKERS] Sequence objects have no global currval operator?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Sequence objects have no global currval operator?
Date: 1998-07-13 22:02:51
Message-ID: 11494.900367371@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> How about SELECT * FROM sequence_table_name?

Ah, of course. The man page for CREATE SEQUENCE only mentions getting
the sequence parameters that way, but you can get the last_value as
well, which is exactly what I need.

Maybe I'll submit a documentation change to make this clearer for the
next guy.

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-07-14 00:11:28 Re: [GENERAL] more nodeError problems and general view failures!
Previous Message Bruce Momjian 1998-07-13 21:50:01 Re: [HACKERS] Sequence objects have no global currval operator?