| From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, jwieck(at)debis(dot)com |
| Cc: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | RE: TODO (was: Re: [HACKERS] Problem with parser) |
| Date: | 1998-08-26 17:18:17 |
| Message-ID: | F10BB1FAF801D111829B0060971D839F3C2256@cpsmail |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > > * 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-08-26 17:18:57 | Re: [HACKERS] Rules for 6.4 finished |
| Previous Message | Edmund Mergl | 1998-08-26 17:06:07 | Re: [HACKERS] Segmentation fault with lo_export |