Postgres Pro
Downloads
Home   >   mailing lists

Re: LIMIT BASED ON PERCENT - Mailing list pgsql-sql

From Guillaume Lelarge
Subject Re: LIMIT BASED ON PERCENT
Date
Msg-id 200911190748.00451.guillaume@lelarge.info
Whole thread Raw
In response to Re: LIMIT BASED ON PERCENT  (Kris Kewley <kris.kewley@gmail.com>)
List pgsql-sql
Tree view 
Le jeudi 19 novembre 2009 à 01:20:24, Kris Kewley a écrit :
> Could you not create a function to do this instead?
>
> Set var_limit = 20% of row count
> Replace subquery with var_limit
>

Sure, see the previous mails from Pavel. You can also put the percent as a
parameter of the function.


--
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com

pgsql-sql by date:

Previous
From: Kris Kewley
Date:
Subject: Re: LIMIT BASED ON PERCENT
Next
From: "Oliveiros C,"
Date:
Subject: Re: need nelp with aggregate functions