Postgres Pro
Downloads
Home   >   mailing lists

Thread: 9.0 release doc

9.0 release doc

From
mark
Date:
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 ..."




thanks.

Re: 9.0 release doc

From
Robert Haas
Date:
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

Re: 9.0 release doc

From
Tom Lane
Date:
Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Jul 27, 2010 at 5:11 PM, mark <dvlhntr@gmail.com> wrote:
>> the 4th bullet point says....
>>
>> "Have SELECT and CREATE TABLE AS return row counts to the client
>> (Boszormenyi Zoltan)
>>
>> 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.

Or more to the point, see the patch being described:

http://archives.postgresql.org/pgsql-committers/2010-02/msg00203.php

            regards, tom lane