PostgeSQL LIMIT pg_numrows
| From: | ceo at l-i-e dot com | Date: | Fri, 13 Dec 2002 17:04:11 +0000 |
| Subject: | PostgeSQL LIMIT pg_numrows | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-128175@lists.php.net to get a copy of this message | ||
In PostgreSQL, I'd like to be able to use a UNION and a LIMIT clause and
have some kind of function to determine how many rows could have come back
without the LIMIT clause.
Is there some kind of function like pg_numrows() that IGNORES the LIMIT
clause? I sure couldn't find it, but maybe I'm just missing it.
I suppose I could do a sub-query:
select count(*) from (select ... union select ...) but that seems kinda
lame...