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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Brian G(dot) Huber" <brianghuber(at)yahoo(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Pls help - Limiting query results by percentage of results
Date: 2003-08-20 21:18:41
Message-ID: 200308201418.41630.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-08-20 21:47:26 Re: Pls help - Limiting query results by percentage of results
Previous Message Brian G. Huber 2003-08-20 19:58:17 Pls help - Limiting query results by percentage of results