Re: 7.1. Overview (The SQL Language)

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. +
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.sgml
new file mode 100644
index 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