Re: Returning the total number of rows as a separate column when using limit

Andreas Joseph Krogh <andreak@officenet.no> writes:
> AFAICS the information about the *total* number of rows is in the "result" 
> somehow. When I execute a "limit 1" query with EXPLAIN ANALYZE, I se the 
> total number of columns in "rows=200819", so the information is there.

That's only an estimate.  Since the query doesn't get executed to
completion thanks to the LIMIT, Postgres really has no idea whether
the estimate is accurate.
        regards, tom lane