> "Roberts, Jon" <[EMAIL PROTECTED]> writes:
> > I have no idea why you can't do a subquery in the limit
>
> It hasn't seemed worth putting any effort into --- AFAIR this is the
> first time anyone's even inquired about it. As you say, you can
always
> use a function.
>
> > And I'm sure someo
"Roberts, Jon" <[EMAIL PROTECTED]> writes:
> I have no idea why you can't do a subquery in the limit
It hasn't seemed worth putting any effort into --- AFAIR this is the
first time anyone's even inquired about it. As you say, you can always
use a function.
> And I'm sure someone will point out a
AIL PROTECTED] [mailto:pgsql-hackers-
> [EMAIL PROTECTED] On Behalf Of Grzegorz Jaskiewicz
> Sent: Friday, February 15, 2008 5:35 AM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] subquery in limit
>
> (just as an example):
> select * from test order by a limit (select
(just as an example):
select * from test order by a limit (select count(*)*0.9 from test);
is not doable in postgresql. Someone recently asked on IRC about,
"SELECT TOP 90 PERCENT" type of query in m$sql.
Any ideas how should this be approach in psql. I ask here, because you
guys probably can
