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

From: Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at>
To: "hackers(at)postgreSQL(dot)org" <hackers(at)postgreSQL(dot)org>
Subject: AW: [HACKERS] Sequence objects have no global currval operator?
Date: 1998-07-14 08:18:24
Message-ID: 01BDAF11.3AB30EC0@zeugswettera.user.lan.at
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.

What do you think of making currval return exactly this, only in the
case where nextval was not yet called by this client ?

I don't think anybody does rely on currval returning null iff nextval was not yet called
in his current session.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1998-07-14 11:04:14 Q about read committed in Oracle...
Previous Message Thomas G. Lockhart 1998-07-14 05:21:18 Re: Recent updates