Re: subquery in limit

"Roberts, Jon" <Jon.Roberts@asurion.com> 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