Skip site navigation (1) Skip section navigation (2)

Re: 9.0 release doc

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: mark <dvlhntr(at)gmail(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: 9.0 release doc
Date: 2010-07-28 00:15:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
On Tue, Jul 27, 2010 at 5:11 PM, mark <dvlhntr(at)gmail(dot)com> wrote:
> Hi am I looking at the 9.0/9.1 release docs.
> (
> 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
The Enterprise Postgres Company

In response to


pgsql-docs by date

Next:From: Tom LaneDate: 2010-07-28 01:13:35
Subject: Re: 9.0 release doc
Previous:From: markDate: 2010-07-27 21:11:46
Subject: 9.0 release doc

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group