🚀 go-pugleaf

> > I would like to confirm....
> >
> > 1) You can't use field alliases when selecting field names. (Invalid
> > command. must specify column name for view select expression)
>
> Sure you can, the alias just has to match the declared name:
>
> CREATE VIEW "FOO" (
>   "MEMBERID",
>   "SURNAME",
>   "FIRSTNAME"
> ) AS
>  select "MEMBER"."OID" as "MEMBERID",
>   "MEMBER"."SURNAME", "MEMBER"."FIRSTNAME"
>  from "MEMBER";
>
> And this of course means you can handle same named columns in joined
tables.

I don't even think you have to use the AS part -> this should work:

> CREATE VIEW "FOO" (
>   "MEMBERID",
>   "SURNAME",
>   "FIRSTNAME"
> ) AS
>  select "MEMBER"."OID",
>   "MEMBER"."SURNAME", "MEMBER"."FIRSTNAME"
>  from "MEMBER";


But you do have to declare the column names in the part before the
query expression.


-- 
Martijn Tonies
Database Workbench - the IBConsole alternative!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com