Problem about pgsql's column alias

From: "milimeter(at)163(dot)com" <milimeter(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem about pgsql's column alias
Date: 2003-04-14 05:16:32
Message-ID: 200304141316.32163."milimeter@163.com"
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-interfaces pgsql-jdbc

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Weiping He 2003-04-14 05:42:49 Encoding conversion problem in AIX 4.3.3?
Previous Message Ron Johnson 2003-04-14 03:30:00 Re: How can I get a column INT4 to be UNSIGNED ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-04-14 05:44:05 Re: Problem about pgsql's column alias
Previous Message Tom Lane 2003-04-14 03:37:40 Re: Anyone working on better transaction locking?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2003-04-14 05:44:05 Re: Problem about pgsql's column alias
Previous Message jason_long 2003-04-14 03:13:16 Please give me a help.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2003-04-14 05:44:05 Re: Problem about pgsql's column alias
Previous Message Tom Lane 2003-04-13 15:30:15 Re: