Re: [INTERFACES] ecpg and getting just assigned serial number - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: [INTERFACES] ecpg and getting just assigned serial number
Date
Msg-id 19990913102726.B3200@gmx.net
Whole thread Raw
In response to ecpg and getting just assigned serial number  (theofilu@eunet.at (Theofilu Andreas))
List pgsql-interfaces
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!


pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] Embedded SQL in C
Next
From: Andreas Theofilu
Date:
Subject: Re: [INTERFACES] ecpg and getting just assigned serial number