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