Postgres Pro
Downloads
Home   >   mailing lists

Re: Pls help - Limiting query results by percentage of results - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Pls help - Limiting query results by percentage of results
Date
Msg-id 200308201418.41630.josh@agliodbs.com
Whole thread Raw
In response to Pls help - Limiting query results by percentage of results  ("Brian G. Huber" <brianghuber@yahoo.com>)
Responses Re: Pls help - Limiting query results by percentage of results
List pgsql-novice
Tree view 
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 by date:

Previous
From: "Brian G. Huber"
Date:
Subject: Pls help - Limiting query results by percentage of results
Next
From: "Gaetano Mendola"
Date:
Subject: Re: Starting PostgreSQL 7.3.4 server with Webmin