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

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to