Обсуждение: RE: TODO (was: Re: [HACKERS] Problem with parser)

Поиск
Список
Период
Сортировка

RE: TODO (was: Re: [HACKERS] Problem with parser)

От
"Jackson, DeJuan"
Дата:
> > > * 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