prepare, execute & oids

From: phazon <phazon(dot)ml(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: prepare, execute & oids
Date: 2006-08-01 16:19:29
Message-ID: 94ffdc2e0608010919q3aca42f7kac0b1dd0992a9a99@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

i've this kind of query:

PREPARE preparedInsert (varchar) AS
INSERT INTO my_table (my_field)
VALUES ($1);
');

and i use it with:

EXECUTE preparedInsert ('test');

I juste want to get the OID of the line inserted. Does anyone know how to do
it ?

Thanks,

Phazon

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mont Rothstein 2006-08-01 16:54:02 Re: Postgres on 64bit Windows Server with WOW64
Previous Message Vivek Khera 2006-08-01 15:52:39 Re: pg_restore performance on solaris 10/6