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
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 ? |
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? |
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. |
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: |