Re: Notes about int8 sequences - Mailing list pgsql-hackers

From Matthew Kirkwood
Subject Re: Notes about int8 sequences
Date
Msg-id Pine.LNX.4.33.0108071551560.6869-100000@sphinx.mythic-beasts.com
Whole thread Raw
In response to Re: Notes about int8 sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, 7 Aug 2001, Tom Lane wrote:

> > I'm not worried about the size of the return type of
> > a sequence, but I like the idea of Oracle-compatible
> > "seq.nextval" syntax.
>
> I didn't realize we had any Oracle-compatibility issues here.  What
> exactly does Oracle's sequence facility look like?

It's exactly "seqname.nextval".  It seems that it
can be used in exactly the places where PG allows
nextval("seqname") (subject to the usual sprinkling
of "from dual"s, of course).

Matthew.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: To be 7.1.3 or not to be 7.1.3?
Next
From: Neil Tiffin
Date:
Subject: Re: Proposal: OID wraparound: summary and proposal