Re: Notes about int8 sequences

From: Matthew Kirkwood <matthew(at)hairy(dot)beasts(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Notes about int8 sequences
Date: 2001-08-07 14:53:27
Message-ID: Pine.LNX.4.33.0108071551560.6869-100000@sphinx.mythic-beasts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fernando Nasser 2001-08-07 15:17:55 Re: OID wraparound: summary and proposal
Previous Message Tom Lane 2001-08-07 14:47:40 Re: To be 7.1.3 or not to be 7.1.3?