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

How about SELECT * FROM sequence_table_name?  Sequence numbers are
stored in their own tables.

> I'm planning to use a "sequence" object to allow multiple clients of a
> shared database to label table records with guaranteed-increasing serial
> numbers.  (The underlying problem is to let all the clients efficiently
> find changes that any one of them makes.  Every insertion or update will
> assign a new sequence number to each new or modified record; then the
> writer must issue a NOTIFY.  Upon being notified, each client can read
> all the newly-modified records with
>     SELECT ... FROM table WHERE seqno > lastseqno;
>     lastseqno := max(seqno seen in retrieved records);


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)