DB2-style INS/UPD/DEL RETURNING
От | Jonah H. Harris |
---|---|
Тема | DB2-style INS/UPD/DEL RETURNING |
Дата | |
Msg-id | 36e682920603120811x547032bbq8b17c5d1e3b3bc32@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: DB2-style INS/UPD/DEL RETURNING
Re: DB2-style INS/UPD/DEL RETURNING Re: DB2-style INS/UPD/DEL RETURNING |
Список | pgsql-hackers |
I was talking with Jonathan Gennick about the INS/UPD/DEL RETURNING stuff, and he recommended looking into the way DB2 handlessimilar functionality. After looking into it a bit, it's more inline with what Tom's suggestion was regarding a queryfrom the operation rather than returning the values in the manner currently required. <br /><br />Here's DB2's syntax...does anyone have any familiarity with it?<br /><br />Simply put, it's sort-of like:<br /><br />SELECT * FROM (FINAL| NEW | OLD) TABLE (INSERT | UPDATE | DELETE)<br /><br clear="all" />I'd like to hear from anyone that's used it tosee if it really is better... logically it seems nicer, but I've never used it. <br /><br />-- <br />Jonah H. Harris, DatabaseInternals Architect<br />EnterpriseDB Corporation<br />732.331.1324<br />
В списке pgsql-hackers по дате отправления: