VALUES lists aliases

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: VALUES lists aliases
Date: 2013-05-21 16:18:09
Message-ID: 519B9E41.4080509@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Next from the stream of doc comments, someone points out that if you
read http://www.postgresql.org/docs/current/static/queries-values.html a
beginner may not understand just what " table alias list" means. If you
start at the beginning of the chapter it makes more sense, but it isn't
necessarily obvious even then.

Easiest fix is to demonstrate this by example, so that's what the
attached patch adds. There was an example of this approach in the full
documentation of VALUES already, but I felt that one was too complicated
for a tutorial section.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com

Attachment Content-Type Size
alias-list-example.patch text/plain 661 bytes

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Robins Tharakan 2013-05-22 00:20:07 CREATE OPERATOR query
Previous Message Greg Smith 2013-05-21 14:19:45 Reserved word "date" in tutorial example