Re: Postgres 8.1 sequences and 'CALL'-syntax

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Cc: "Schnabl, Sebastian" <s(dot)schnabl(at)qualitype(dot)de>
Subject: Re: Postgres 8.1 sequences and 'CALL'-syntax
Date: 2006-05-08 21:23:54
Message-ID: 200605082323.55081.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Miroslav Šulc 2006-05-09 08:54:19 Re: Most efficient way to hard-sort records
Previous Message Jorge Godoy 2006-05-07 23:46:04 Re: Creating nested functions with plpgsql