Re: [HACKERS] SELECT ... LIMIT (trial implementation)

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Jan Wieck <jwieck(at)debis(dot)com>
Cc: PostgreSQL HACKERS <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] SELECT ... LIMIT (trial implementation)
Date: 1998-10-18 17:58:41
Message-ID: Pine.GSO.3.96.SK.981018215259.17519D-100000@ra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jan,

I tested your patch on my Linux box and it works ok, except
aggregates functions doesn't work properly, for example
count(*) always produces 0

kdo=> select count(*) from work_flats limit 10,1000;
count
-----
(0 rows)

while

kdo=> select rooms from work_flats limit 10,1000;
rooms
-----
3
3
3
3
3
3
3
3
3
3
(10 rows)

Regards,

Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Paul A Vixie 1998-10-18 18:22:32 Re: [HACKERS] Re: inet/cidr/bind
Previous Message Oleg Bartunov 1998-10-18 17:45:24 Re: [HACKERS] SELECT ... LIMIT (trial implementation)