Skip site navigation (1) Skip section navigation (2)

doc question about column name alias

From: Weiping He <laser(at)zhengmai(dot)com(dot)cn>
To: pgsql-docs(at)postgresql(dot)org
Subject: doc question about column name alias
Date: 2001-06-25 14:38:46
Message-ID: 3B374CF6.C1AB82F0@zhengmai.com.cn (view raw or flat)
Thread:
Lists: pgsql-docs
Hi,
    I'm translating 7.1.2's doc to Chinese, and got one question while
doing these,
in queries.sgml line 795:

SELECT a AS b FROM table1 ORDER BY a;

I think it should be:

SELECT a AS b FROM table1 ORDER BY b;

but from the context:"   References to column names in the FROM clause
that are renamed in the select list are also allowed:"
it seems the original is correct. Am I misunderstood? How the SQL
standard saids?
Thanks.

    regards    laser



Responses

pgsql-docs by date

Next:From: Bruce MomjianDate: 2001-06-25 15:06:19
Subject: Re: doc question about column name alias
Previous:From: Fred T. KroghDate: 2001-06-23 03:50:17
Subject: At your request

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group