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...




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to