Postgres Pro
Downloads
Home   >   mailing lists

prepare, execute & oids - Mailing list pgsql-general

From phazon
Subject prepare, execute & oids
Date
Msg-id 94ffdc2e0608010919q3aca42f7kac0b1dd0992a9a99@mail.gmail.com
Whole thread Raw
Responses Re: prepare, execute & oids  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: pg_restore performance on solaris 10/6
Next
From: "Mont Rothstein"
Date:
Subject: Re: Postgres on 64bit Windows Server with WOW64