Can I use “RETURNING id” in an insert statement with postgresql version 8.1.10? I cannot find a clear example on how to use it to capture the id created by the insert statement into a variable in PHP. Many examples are like this but don’t state how to access the returned id: INSERT INTO Addresses (address, city, state, postalcode) VALUES ('123 Main St.','Springfield','MA','01109') RETURNING id; Thanks Marc
|