CREATE VIEW fix - Mailing list pgsql-hackers

From Thomas Lockhart
Subject CREATE VIEW fix
Date
Msg-id 38C52AEB.87DF5035@alumni.caltech.edu
Whole thread Raw
Responses Re: [HACKERS] CREATE VIEW fix  ("Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>)
Re: [HACKERS] CREATE VIEW fix  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
I've got patches to fix the CREATE VIEW command to support SQL92
syntax for result column names, a la
 CREATE VIEW (a, b, c) AS SELECT ...

It is an almost trivial fix, requiring the addition of a single field
in the View structure and a few lines of code in analyze.c.

I'll commit this at the same time I commit support for the SQL92
OVERLAPS operator, which will need an initdb anyway since there are a
few new functions in pg_proc. I believe that we have at least one
other patch coming which will force an initdb anyway, and I'll
coordinate with that.
                     - Thomas

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


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: BIT/BIT VARYING names (was Re: [HACKERS] Beta for 4:30AST)
Next
From: Andrzej Mazurkiewicz
Date:
Subject: How can I create trigger on system table, for on example pg_class ???