Re: [GENERAL] Row Count?

>> > 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(dot)ceulemans(at)nice(dot)be
Nice Software Solutions - http://www.nice.be
Eglegemweg 3, 2811 Hombeek - Belgium
Tel +32(0)15 412953 - Fax +32(0)15 412954