"Roberts, Jon" <[EMAIL PROTECTED]> writes:
> I have no idea why you can't do a subquery in the limit
It hasn't seemed worth putting any effort into --- AFAIR this is the
first time anyone's even inquired about it. As you say, you can always
use a function.
> And I'm sure someone will point out a more efficient way to write my
> function without using pl/pgsql. :)
Only that it doesn't seem a particularly bright idea to use SECURITY
DEFINER for a function that will execute any arbitrary caller-provided
SQL ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
