VALUES lists aliases

Started by Greg Smithalmost 13 years ago2 messagesdocs
Jump to latest
#1Greg Smith
gsmith@gregsmith.com

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@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com

Attachments:

alias-list-example.patchtext/plain; charset=UTF-8; name=alias-list-example.patch; x-mac-creator=0; x-mac-type=0Download+10-1
#2Peter Eisentraut
peter_e@gmx.net
In reply to: Greg Smith (#1)
Re: VALUES lists aliases

On Tue, 2013-05-21 at 12:18 -0400, Greg Smith wrote:

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.

committed

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs