"Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)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