doc question about column name alias - Mailing list pgsql-docs

From Weiping He
Subject doc question about column name alias
Date
Msg-id 3B374CF6.C1AB82F0@zhengmai.com.cn
Whole thread Raw
Responses Re: doc question about column name alias  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: doc question about column name alias  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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



pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Embedding postgresql
Next
From: Tom Lane
Date:
Subject: Re: doc question about column name alias