>> > SELECT * FROM foo WHERE ROW_COUNT < 10;
>> > Is there anything like "ROW_COUNT" or "ROWCOUNT" in PostgreSQL?
>
Look through the archives with LIMIT.
I believe in postgresql 6.4.2 you can use something like
set QUERY_LIMIT TO '10';
and after you've done:
reset QUERY_LIMIT;
and in 6.5 I think there is even a better way?
Regards
Wim Ceulemans - wim.ceulemans@nice.be
Nice Software Solutions - http://www.nice.be
Eglegemweg 3, 2811 Hombeek - Belgium
Tel +32(0)15 412953 - Fax +32(0)15 412954