Re: rownum

Поиск
Список
Период
Сортировка
От chester c young
Тема Re: rownum
Дата
Msg-id 20030215045410.15935.qmail@web12707.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: rownum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
> Considering that it can trivially be done on the client side, I think
> it would be a hard sell to put such a wart into the protocol ...

having used Oracle for many years, I cannot think of a project in which
I did not use rownum, including within procedures and triggers and
subqueries.  can usually be easily done - loop within loop - but more
easily and bugfree as column within select.

by "wart" do you mean aesthetically or code-wise?  naively, it seems
like pg is already keeping a row counter to implement limit.

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com


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

Предыдущее
От: Brad Hilton
Дата:
Сообщение: Re: sub-query optimization
Следующее
От: "Tomasz Myrta"
Дата:
Сообщение: Re: sub-query optimization