pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feed9.0 release doc
3+ messages / 3 participants
[nested] [flat]
* 9.0 release doc
@ 2010-07-27 21:11 mark <dvlhntr@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: mark @ 2010-07-27 21:11 UTC (permalink / raw)
To: pgsql-docs
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 9.0 release doc
@ 2010-07-28 00:15 Robert Haas <robertmhaas@gmail.com>
parent: mark <dvlhntr@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Robert Haas @ 2010-07-28 00:15 UTC (permalink / raw)
To: mark <dvlhntr@gmail.com>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 9.0 release doc
@ 2010-07-28 01:13 Tom Lane <tgl@sss.pgh.pa.us>
parent: Robert Haas <robertmhaas@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2010-07-28 01:13 UTC (permalink / raw)
To: Robert Haas <robertmhaas@gmail.com>; +Cc: mark <dvlhntr@gmail.com>; pgsql-docs
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-07-28 01:13 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-27 21:11 9.0 release doc mark <dvlhntr@gmail.com>
2010-07-28 00:15 ` Robert Haas <robertmhaas@gmail.com>
2010-07-28 01:13 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox