> If you only need the count when you've got the results, most PG client > interfaces will tell you how many rows you've got. What language is your app > in?
PHP. But I have only a subset of the results, retrieved via a query with a "LIMIT <m>" clause, so $pg_numrows is m. And retrieving all results (i.e. no LIMIT) is at least as expensive as COUNT(*). -David ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org