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          http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +
commit 90108c9aab51840a0fa7bcb11a2da09204d5b003
Author: Bruce Momjian 
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;
  
    Assuming that there is a table called table1,
!   this command would retrieve all rows and all columns from
    table1.  (The method of retrieval depends on the
    client application.  For example, the
    psql program will display an ASCII-art
--- 41,47 ----
  SELECT * FROM table1;
  
    Assuming that there is a table called table1,
!   this command would retrieve all rows and all user-defined columns from
    table1.  (The method of retrieval depends on the
    client application.  For example, the
    psql program will display an ASCII-art