From: Bruce Momjian <bruce@momjian.us>
To: Grzegorz Szpetkowski <gszpetkowski@gmail.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: 7.1. Overview (The SQL Language)
Date: Sat, 10 Sep 2011 10:47:15 -0400 (EDT)
Message-ID: <201109101447.p8AElF813203@momjian.us> (raw)
bruce wrote:
> Grzegorz Szpetkowski wrote:
> > http://www.postgresql.org/docs/9.0/static/queries-overview.html
> >
> > "Assuming that there is a table called table1, this command would
> > retrieve all rows and all columns from table1."
> >
> > Maybe it's worth adding:
> >
> > "Assuming that there is a table called table1, this command would
> > retrieve all rows and all columns (excluding system columns described
> > at Section 5.4) from table1."
>
> I considered this but it seems like too much detail for the overview
> section.
On second thought, I added the "user-defined" modifier to the sentence;
applid patch attached.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Attachments:/rtmp/user-defined (text/plain, 1.1K) download
commit 90108c9aab51840a0fa7bcb11a2da09204d5b003
Author: Bruce Momjian <bruce@momjian.us>
Date: Sat Sep 10 10:45:55 2011 -0400
Document that only user-defined columns are expanded by SELECT *.
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgmlnew file mode 100644index 7ca640e..a3dadbe
*** a/doc/src/sgml/queries.sgml
--- b/doc/src/sgml/queries.sgml
***************
*** 41,47 ****
SELECT * FROM table1;
</programlisting>
Assuming that there is a table called <literal>table1</literal>,
! this command would retrieve all rows and all columns from
<literal>table1</literal>. (The method of retrieval depends on the
client application. For example, the
<application>psql</application> program will display an ASCII-art
--- 41,47 ----
SELECT * FROM table1;
</programlisting>
Assuming that there is a table called <literal>table1</literal>,
! this command would retrieve all rows and all user-defined columns from
<literal>table1</literal>. (The method of retrieval depends on the
client application. For example, the
<application>psql</application> program will display an ASCII-art
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, gszpetkowski@gmail.com
Subject: Re: 7.1. Overview (The SQL Language)
In-Reply-To: <201109101447.p8AElF813203@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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