In my system I alway do a select X from Y. followed by a select
count() from Y to get the number of row in my first request. I heard it
was possible to get the total number of rows from a select in a
Today I saw in PGAdminIII that it gives the count(*) from any query that
return more that 100 lines: This query return more than 100 rows (12234
rows) do you want to display them.
So did I miss something obvious. Is it possible to get the total number
of row returned from a query without doing another select.
Thanks to confirm that :-)
Have a goog week-end
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2005-04-15 20:04:06|
|Subject: Re: Getting the number or row returned by a select. Alway|
|Previous:||From: Dave Cramer||Date: 2005-04-15 00:33:45|
|Subject: Re: Error with a hibernate query|