public inbox for [email protected]help / color / mirror / Atom feed
7.1. Overview (The SQL Language) 4+ messages / 4 participants [nested] [flat]
* 7.1. Overview (The SQL Language) @ 2011-05-11 19:38 Grzegorz Szpetkowski <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Grzegorz Szpetkowski @ 2011-05-11 19:38 UTC (permalink / raw) To: pgsql-docs 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. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: 7.1. Overview (The SQL Language) @ 2011-06-13 15:05 Robert Haas <[email protected]> parent: Grzegorz Szpetkowski <[email protected]> 1 sibling, 1 reply; 4+ messages in thread From: Robert Haas @ 2011-06-13 15:05 UTC (permalink / raw) To: Grzegorz Szpetkowski <[email protected]>; +Cc: pgsql-docs On Wed, May 11, 2011 at 3:38 PM, Grzegorz Szpetkowski <[email protected]> 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 <literal>*</literal> 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: 7.1. Overview (The SQL Language) @ 2011-06-13 15:36 Tom Lane <[email protected]> parent: Robert Haas <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Tom Lane @ 2011-06-13 15:36 UTC (permalink / raw) To: Robert Haas <[email protected]>; +Cc: Grzegorz Szpetkowski <[email protected]>; pgsql-docs Robert Haas <[email protected]> writes: > On Wed, May 11, 2011 at 3:38 PM, Grzegorz Szpetkowski > <[email protected]> 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: 7.1. Overview (The SQL Language) @ 2011-09-10 13:32 Bruce Momjian <[email protected]> parent: Grzegorz Szpetkowski <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Bruce Momjian @ 2011-09-10 13:32 UTC (permalink / raw) To: Grzegorz Szpetkowski <[email protected]>; +Cc: pgsql-docs 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 <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-09-10 13:32 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-05-11 19:38 7.1. Overview (The SQL Language) Grzegorz Szpetkowski <[email protected]> 2011-06-13 15:05 ` Robert Haas <[email protected]> 2011-06-13 15:36 ` Tom Lane <[email protected]> 2011-09-10 13:32 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox