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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-docs by date

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