From: | "Kris Zawadka" <kris(at)h3x(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Last Inserted row. |
Date: | 2002-03-14 09:50:28 |
Message-ID: | 000001c1cb3d$acb3e980$080aa8c0@car4youintern.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
I'm sure this must have been covered before but the search engine for
the mailing list is currently down and I couldn't find any help on the
web.
I would like to know if it's possible to return a data set after an
insert. In MS SQL it's quite easy to create a trigger that return's
information about the inserted record such as primary ID and so forth.
Using a Function & Trigger I can return the information with RAISE but
obviously PHP or any other language won't treat that as a row from a
result set.
I wish to perform this task at the trigger/function level for
abstraction reasons and want to avoid having to multiple select
statements for something that should be easily done in one.
Thanks for your help,
Kris Zawadka
From | Date | Subject | |
---|---|---|---|
Next Message | Jakub Gako | 2002-03-14 11:12:49 | how to install Postgresql on Windows2000 ? Please send me detaily discription. |
Previous Message | Devrim GUNDUZ | 2002-03-14 09:24:16 | Re: Distributed databases |
From | Date | Subject | |
---|---|---|---|
Next Message | Graham Leggett | 2002-03-14 10:41:34 | character sets and results |
Previous Message | Erwin Ambrosch | 2002-03-14 09:08:13 | JDBC-Question |