Re: How to find LIMIT in SQL standard

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: How to find LIMIT in SQL standard
Дата
Msg-id 20030925074435.Q79424@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: How to find LIMIT in SQL standard  (Rory Campbell-Lange <rory@campbell-lange.net>)
Список pgsql-general
On Thu, 25 Sep 2003, Rory Campbell-Lange wrote:

> Thanks for the reply, Stephan. Sorry about the late reply.
>
> Your dissection of the standard (and thanks for the translation, by
> the way!) is a clear reason to use unique row ids. Unfortunately the
> project I am reporting bugs on does not do this at present.

Well, if you're looking for a PostgreSQL only solution (to throw in the
switch), I think someone already sent a query using oid and a subselect.
It's not going to perform super well probably and will only work on
tables with oids, but it should only update one row.

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

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: "Expiring" transactions?
Следующее
От: Ericson Smith
Дата:
Сообщение: Triggers and COPY