Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9E42AB5DBD6 for ; Mon, 13 Jun 2011 12:05:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 48488-09 for ; Mon, 13 Jun 2011 15:05:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ey0-f174.google.com (mail-ey0-f174.google.com [209.85.215.174]) by mail.postgresql.org (Postfix) with ESMTP id 993B2B5DBC6 for ; Mon, 13 Jun 2011 12:05:48 -0300 (ADT) Received: by eyx24 with SMTP id 24so1628894eyx.19 for ; Mon, 13 Jun 2011 08:05:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=dbNvymoTrfDDXo2NtiUtBHi8tanI0k0oZhPMFDxwZ3E=; b=LevuIPU9PAJ5fTAPD9jkdnQs2VnUZmUTGUJpke/g/nMX/mZ0s5FYWDsoPGeNKFQElb EaDGredkrTSrWFTNbMYBg8TclxnVerCtfTY7SnzEytlTdTHRTxJYLoWAltHNE7QePMvj chiyP7nJM5LBp1yUkRJ0QmuAPsuwXl5fi0hK0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=iB2Jd/YPYVkT/jGbQMCYBz+UBk+5kYCC3pAWBoX6P4AoINNc2VHXbCXceecWuunFLO kWqdDStnVOldr/0zk4O9j4CeQrRkPDWFOFGQP7fvi6DUv4Pll59vUh4rbPt9qfCKVn0o oB0Yc02/3HWkxV9nmawe+wxxGp0tAqhkRs/aQ= MIME-Version: 1.0 Received: by 10.14.101.14 with SMTP id a14mr2352305eeg.55.1307977547322; Mon, 13 Jun 2011 08:05:47 -0700 (PDT) Received: by 10.14.96.4 with HTTP; Mon, 13 Jun 2011 08:05:47 -0700 (PDT) In-Reply-To: References: Date: Mon, 13 Jun 2011 11:05:47 -0400 Message-ID: Subject: Re: 7.1. Overview (The SQL Language) From: Robert Haas To: Grzegorz Szpetkowski Cc: pgsql-docs@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201106/35 X-Sequence-Number: 6809 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