Andres Freund <and...@anarazel.de> writes: > On Wednesday 21 October 2009 05:37:36 Thach Anh Tran wrote: >> the LIMIT clause is not reply correct number of rows and rows returns.
> Read the second caution block in the relevant section of the manual: > http://www.postgresql.org/docs/current/interactive/sql-select.html#SQL-FOR- > UPDATE-SHARE There has been some discussion of changing that, and it might happen for 8.5. It's essentially impossible to fix in existing releases though, because changing it requires a major restructuring of the executor. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs