Re: Postgres 8.1 sequences and 'CALL'-syntax

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Postgres 8.1 sequences and 'CALL'-syntax
Дата
Msg-id 200605082323.55081.peter_e@gmx.net
обсуждение исходный текст
Ответ на Postgres 8.1 sequences and 'CALL'-syntax  ("Schnabl, Sebastian" <s.schnabl@qualitype.de>)
Список pgsql-sql
Schnabl, Sebastian wrote:
> I use postgres 8.1 and trie to run jboss over sequoia-ha
> (http://sequoia.continuent.org/HomePage). But i have an problem with
> sequences. Sequoia claims to support for good reasons and
> db-independece only "sql-standard(s)". Therefore they DON'T support
> the postgres-specific "select nextval('seq_name')". Instead they gave
> me the hint to use the sql-conform "call nexval('seq_name')".

That statement is not any more SQL conforming than the other.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


В списке pgsql-sql по дате отправления:

Предыдущее
От: Jorge Godoy
Дата:
Сообщение: Re: Creating nested functions with plpgsql
Следующее
От: Miroslav Šulc
Дата:
Сообщение: Re: Most efficient way to hard-sort records