On Tue, Jul 27, 2010 at 5:11 PM, mark <dvlhntr@gmail.com> wrote:
> Hi am I looking at the 9.0/9.1 release docs.
> (http://developer.postgresql.org/pgdocs/postgres/release-9-0.html)
>
>
>
> E.1.3.2. Queries
> the 4th bullet point says....
>
> "Have SELECT and CREATE TABLE AS return row counts to the client
> (Boszormenyi Zoltan)
>
> For drivers that support this feature, this saves an entire round-trip
> to the client, allowing result counts and pagination to be calculated
> without a second COUNT query.
>
> psql does not display these counts. "
>
>
>
>
> after asking around on #postgresql was wondering if it should read
>
> "Have SELECT INTO and ..."
The release notes as written are correct. Plain old SELECT (without
SELECT INTO) also returns the number of tuples in the command tag.
But psql does not display it. See src/bin/psql/command.c, in
PrintQueryResults, about 15 lines down from the top of the function.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company