Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group