Bruce, Ah, yes, which reminds me I need to generate that doc patch.
> I am wondering if a documentation warning about the use of FOR UPDATE > and LIMIT is a good idea. If we can't be sure the LIMIT will return a > guaranteed number of rows, should we just disallow that combination? I > realize such a case is rare. Should we emit a warning when it happens? Well, limit+for update can be useful under some circumstances, as long as you understand its limitations. We found a workaround. So I'd oppose disallowing it. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org