php - How UPDATE and SELECT at the same time

Question

I need to update some rows of the tables and then display these rows. Is there a way to do this with one single query and avoid this 2 query ? :

UPDATE table SET foo=1 WHERE boo=2

SELECT * from table WHERE ( foo=1 ) AND ( boo=2 )

Answer 1

In PostgreSQL v8.2 and newer you can do this using RETURNING:

UPDATE table
SET foo=1
WHERE boo=2
RETURNING *