Re: [HACKERS] CREATE VIEW fix - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] CREATE VIEW fix
Date
Msg-id 38C5E53D.AE6F7076@alumni.caltech.edu
Whole thread Raw
In response to CREATE VIEW fix  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
> >   CREATE VIEW (a, b, c) AS SELECT ...
> Hmm, couldn't you just rewrite the SELECT d, e, f ... part to use the
> AS syntax? I was thinking that both:
>    CREATE VIEW (a, b, c) AS SELECT d, e, f ...
>    CREATE VIEW AS SELECT d AS a, e AS b, f AS c ...
> should result in the same VIEW being created. But, hey, don't let me
> knock already written code!

Not at all. Next time I'll let you write it, since this is how I
implemented it :)
                  - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] 'LIKE' enhancement suggestion
Next
From: Thomas Lockhart
Date:
Subject: Re: BIT/BIT VARYING names (was Re: [HACKERS] Beta for 4:30AST)