[EMAIL PROTECTED] writes: > SELECT * FROM employees > WHERE status = 'A' > LIMIT 1 > FOR UPDATE;
> The problem, in the previous sentence, is block every record on
> employees, although we want one record, we want limit 1.
I do not believe that. Could you give a more complete example of
your problem?
It would also help if you'd state which Postgres version you're using.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
