Re: subquery in limit

Поиск
Список
Период
Сортировка
От Roberts, Jon
Тема Re: subquery in limit
Дата
Msg-id 1A6E6D554222284AB25ABE3229A927627155C0@nrtexcus702.int.asurion.com
обсуждение исходный текст
Ответ на Re: subquery in limit  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> "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 ...
>

LOL!  I knew something in my code would trigger a response.  :)



Jon


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: subquery in limit
Следующее
От: Christian Robottom Reis
Дата:
Сообщение: CVS repository invalid revision