Re: [INTERFACES] ecpg and getting just assigned serial number

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: [INTERFACES] ecpg and getting just assigned serial number
Дата
Msg-id 19990913102726.B3200@gmx.net
обсуждение исходный текст
Ответ на ecpg and getting just assigned serial number  (theofilu@eunet.at (Theofilu Andreas))
Список 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 по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: [INTERFACES] Embedded SQL in C
Следующее
От: Andreas Theofilu
Дата:
Сообщение: Re: [INTERFACES] ecpg and getting just assigned serial number