Last Inserted row.
| От | Kris Zawadka |
|---|---|
| Тема | Last Inserted row. |
| Дата | |
| Msg-id | 000001c1cb3d$acb3e980$080aa8c0@car4youintern.ch обсуждение |
| Ответ на | JDBC-Question (Erwin Ambrosch <ambre@ebutec.com>) |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: