From: milimeter@163.com <milimeter@163.com>
To: pgsql-general@postgresql.org
Subject: Problem about pgsql's column alias
Date: Mon, 14 Apr 2003 13:16:32 +0800
Message-ID: <200304141316.32163."milimeter@163.com"> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: milimeter@163.com, pgsql-general@postgresql.org
Subject: Re: Problem about pgsql's column alias
In-Reply-To: <200304141316.32163."milimeter@163.com">
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox