pgsql-bugs(at)postgresql(dot)org 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