[ADMIN] returning id

[Lonni J Friedman]

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.
INSERT INTO Addresses (address, city, state, postalcode) VALUES ('123 Main
St.','Springfield','MA','01109') RETURNING id;

Is there a reason why you can't use the currval function:
select currval('id_seq')

[Tom Lane]

Can I use "RETURNING id" in an insert statement with postgresql version 8.1.10?

No. I don't recall just when RETURNING was added, but for sure it was
after 8.1.

regards, tom lane

[Guillaume Lelarge]

Post by Tom Lane

Can I use "RETURNING id" in an insert statement with postgresql version 8.1.10?

No. I don't recall just when RETURNING was added, but for sure it was
after 8.1.

I checked. It appeared in 8.2. Sooner than I expected actually.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com