Re: Notes about int8 sequences

Поиск
Список
Период
Сортировка
От Matthew Kirkwood
Тема Re: Notes about int8 sequences
Дата
Msg-id Pine.LNX.4.33.0108071551560.6869-100000@sphinx.mythic-beasts.com
обсуждение исходный текст
Ответ на Re: Notes about int8 sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: To be 7.1.3 or not to be 7.1.3?
Следующее
От: Neil Tiffin
Дата:
Сообщение: Re: Proposal: OID wraparound: summary and proposal