X-Original-To: pgsql-general@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AEC754760E3 for ; Mon, 14 Apr 2003 01:16:29 -0400 (EDT) Received: from sm212.163.com (unknown [202.108.44.212]) by postgresql.org (Postfix) with ESMTP id B73CD47580B for ; Mon, 14 Apr 2003 01:16:22 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by sm212.163.com (Postfix) with SMTP id E5D851C776521 for ; Mon, 14 Apr 2003 13:16:34 +0800 (CST) Received: from 192.168.0.80 (unknown [218.247.247.226]) by 192.168.1.212 (Coremail:www.163.com) with SMTP id F8kAADJEmj4yAffi.1 for ; Mon, 14 Apr 2003 13:16:34 +0800 (CST) From: "milimeter@163.com" Reply-To: milimeter@163.com Organization: milimeter@163.com To: pgsql-general@postgresql.org Subject: Problem about pgsql's column alias Date: Mon, 14 Apr 2003 13:16:32 +0800 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200304141316.32163."milimeter@163.com"> X-Spam-Status: No, hits=-0.3 required=5.0 tests=BAYES_20,RCVD_IN_OSIRUSOFT_COM,RCVD_IN_RFCI,RCVD_IN_SBL, USER_AGENT version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/798 X-Sequence-Number: 40863 Hello, everybody I found that in postgresql, we can only use "select login_name as name from users;" to get an alias "name" for column "login_name", but in most other databases we can omit the "as", that is "select login_name name from users;". Now I will convert a lot of program from oracle to postgresql, there're so many place to be correct from "AAA BBB" to "AAA as BBB", can anybody give me a good method to do that? Or, if the next version of postgresql will have the same feature as other databases? Thanks a lot, Yours, mili