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

CREATE VIEW fix

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

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-03-07 16:19:08
Subject: Re: [HACKERS] alter_table.sql
Previous:From: Andrzej MazurkiewiczDate: 2000-03-07 16:14:30
Subject: How can I create trigger on system table, for on example pg_class ???

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