Date: Mon, 13 Sep 1999 10:27:26 +0200
From: Michael Meskes <meskes@postgresql.org>
To: Theofilu Andreas <theofilu@eunet.at>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] ecpg and getting just assigned serial number
Message-ID: <19990913102726.B3200@gmx.net>
Mail-Followup-To: Theofilu Andreas <theofilu@eunet.at>,
	pgsql-interfaces@postgresql.org
References: <199909121425.QAA05055@eunet.at>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
In-Reply-To: <199909121425.QAA05055@eunet.at>;
	from Theofilu Andreas on Sun, Sep 12, 1999 at 04:25:17PM +0200

On Sun, Sep 12, 1999 at 04:25:17PM +0200, Theofilu Andreas wrote:
> I'm using 'ecpg' to develop my application, because it's mostly compatible
> to Informix's 'esqlc'. However. I have a table with a field of type
> 'serial'. Now I've no problem to insert any sentences into this table, but
> immediately after inserting a new sentence I need the newly assigned number
> to the serial field in the table. How can I access this number?
> With Informix I got this number in a field of structure 'sqlca'. With
> PostgreSQL the same field in this structure exists but contains always 0,
> as documented.

Where exactly does Informix return it? sqlca[?].

Also does anyone know whether the backend returns that number somewhere?

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!