Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-08-26 17:18:57
Subject: Re: [HACKERS] Rules for 6.4 finished
Previous:From: Edmund MerglDate: 1998-08-26 17:06:07
Subject: Re: [HACKERS] Segmentation fault with lo_export

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group