| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Postgres Hackers List <hackers(at)postgresql(dot)org> |
| Subject: | CREATE VIEW fix |
| Date: | 2000-03-07 16:14:35 |
| Message-ID: | 38C52AEB.87DF5035@alumni.caltech.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-03-07 16:19:08 | Re: [HACKERS] alter_table.sql |
| Previous Message | Andrzej Mazurkiewicz | 2000-03-07 16:14:30 | How can I create trigger on system table, for on example pg_class ??? |