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 Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2000-03-07 16:19:08|
|Subject: Re: [HACKERS] alter_table.sql |
|Previous:||From: Andrzej Mazurkiewicz||Date: 2000-03-07 16:14:30|
|Subject: How can I create trigger on system table, for on example pg_class ???|