Re: Pls help - Limiting query results by percentage of results

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Pls help - Limiting query results by percentage of results
Дата
Msg-id 200308201418.41630.josh@agliodbs.com
обсуждение исходный текст
Ответ на Pls help - Limiting query results by percentage of results  ("Brian G. Huber" <brianghuber@yahoo.com>)
Ответы Re: Pls help - Limiting query results by percentage of results  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Дерево обсуждения 
Brian,

> I am trying to limit the results of a query using the LIMIT clause - but
instead of an absolute number I would like to limit by a percentage of rows
returned.

We don't have that feature, I'm afraid.   You'd have to write a procedure or
subroutine which calculated that number an then passed it to LIMIT.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

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

Предыдущее
От: "Brian G. Huber"
Дата:
Сообщение: Pls help - Limiting query results by percentage of results
Следующее
От: "Gaetano Mendola"
Дата:
Сообщение: Re: Starting PostgreSQL 7.3.4 server with Webmin