Received: from mail.zhengmai.net.cn ([202.99.6.10])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f5PEX2a52185
	for <pgsql-docs@postgresql.org>; Mon, 25 Jun 2001 10:33:02 -0400 (EDT)
	(envelope-from laser@zhengmai.com.cn)
Received: from zhengmai.com.cn (laser@[211.99.162.69])
	by mail.zhengmai.net.cn (8.9.3/8.9.3) with ESMTP id WAA18674
	for <pgsql-docs@postgresql.org>; Mon, 25 Jun 2001 22:32:07 +0800 (BST)
Message-ID: <3B374CF6.C1AB82F0@zhengmai.com.cn>
Date: Mon, 25 Jun 2001 22:38:46 +0800
From: Weiping He <laser@zhengmai.com.cn>
X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.18 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-docs@postgresql.org
Subject: doc question about column name alias
Content-Type: text/plain; charset=gb2312
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200106/39
X-Sequence-Number: 837

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