> > > * Allow views to specify column names outside SELECT statement
> >
> > ??? what is meant by that?
>
> I have no idea. I am removing it. Does anyone else know what it
> means?
>
I think it was the example from ...
Well, the syntax was
CREATE VIEW my_view(column1, column2, column3) AS
SELECT t1 * m2, c2, j FROM my_table1
UNION ALL
SELECT m2, c3, n FROM my_table2;
instead of:
CREATE VIEW my_view AS
SELECT t1 * m2 AS column1, c2 AS column2, j AS column3 FROM my_table1
UNION ALL
SELECT m2, c3, n FROM my_table2;
Hope this helps,
-DEJ
