Re: 7.1. Overview (The SQL Language)
Re: 7.1. Overview (The SQL Language)
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Robert Haas writes: > On Wed, May 11, 2011 at 3:38 PM, Grzegorz Szpetkowski > wrote: >> 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." > Since this is a basic SQL tutorial, we don't want to get too far down > into the weeds, or people will get confused. I agree. Mentioning system columns at all in this place seems like too much information. regards, tom lane
Re: 7.1. Overview (The SQL Language)
От:
Bruce Momjian <bruce@momjian.us>
Дата:
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. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
Re: 7.1. Overview (The SQL Language)
От:
Bruce Momjian <bruce@momjian.us>
Дата:
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
7.1. Overview (The SQL Language)
От:
Grzegorz Szpetkowski <gszpetkowski@gmail.com>
Дата:
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." Regards, G. Sz.
Re: 7.1. Overview (The SQL Language)
От:
Robert Haas <robertmhaas@gmail.com>
Дата:
On Wed, May 11, 2011 at 3:38 PM, 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." Since this is a basic SQL tutorial, we don't want to get too far down into the weeds, or people will get confused. The next sentence would need some thought, too: The select list specification * means all columns that the table expression happens to provide. Possibly we could add a footnote? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
