fetch auto-increment

From: Stefan Allers <Stefan(dot)Allers(at)gmx(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: fetch auto-increment
Date: 2002-09-15 19:59:30
Message-ID: 13336.1032119970@www61.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I want to insert a row in the following table:

CREATE TABLE PATIENT (PATIN serial,PATN varchar(64) NULL);

I want to insert a patient name in the patient table with s.th. like:

insert into patient(patn) values('Doe,John')

Is there a simple way to fetch the datbase generated patin value
without doing a new database query (select patin from patient where ...)
in odbc?

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net

Browse pgsql-odbc by date

  From Date Subject
Next Message Sebastian Hetze 2002-09-16 05:53:34 SQLProcedureColumns
Previous Message Dave Page 2002-09-13 20:03:37 Re: POSSIBLE BUG.