note 103673 added to function.pg-last-oid

From: Date: Wed, 27 Apr 2011 16:14:44 +0000
Subject: note 103673 added to function.pg-last-oid
Groups: php.notes 
Request: Send a blank email to php-notes+get-179200@lists.php.net to get a copy of this message
Hi, Version 9 supports the optional RETURNING clause causes INSERT to compute and return value(s) based on each row actually inserted. This is primarily useful for obtaining values that were supplied by defaults, such as a serial sequence number. However, any expression using the table's columns is allowed. The syntax of the RETURNING list is identical to that of the output list of SELECT. If the UPDATE command contains a RETURNING clause, the result will be similar to that of a SELECT statement containing the columns and values defined in the RETURNING list, computed over the row(s) updated by the command. Basically you can fetch all updated or inserted rows from the resource like if you executed SELECT statement. ---- Server IP: 69.147.83.197 Probable Submitter: 99.240.17.121 ---- Manual Page -- http://www.php.net/manual/en/function.pg-last-oid.php Edit -- https://master.php.net/note/edit/103673 Del: integrated -- https://master.php.net/note/delete/103673/integrated Del: useless -- https://master.php.net/note/delete/103673/useless Del: bad code -- https://master.php.net/note/delete/103673/bad+code Del: spam -- https://master.php.net/note/delete/103673/spam Del: non-english -- https://master.php.net/note/delete/103673/non-english Del: in docs -- https://master.php.net/note/delete/103673/in+docs Del: other reasons-- https://master.php.net/note/delete/103673 Reject -- https://master.php.net/note/reject/103673 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#179200) next »