Hi
I want to SELECT at max. 10 rows and SET a variable for the
select 10 rows with the same query.
Under mysql i can use:
UPDATE table SET uniq_iq=12345 LIMIT 10
SELECT * FROM table WHERE uniq_id=1234;
This is not supported by postgres.
Is there some easy solution that does not require locking?
-tp