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

Re: [HACKERS] CREATE VIEW fix

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>
Cc: Postgres Hackers List <hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] CREATE VIEW fix
Date: 2000-03-08 05:29:33
Message-ID: 38C5E53D.AE6F7076@alumni.caltech.edu (view raw or flat)
Thread:
Lists: 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2000-03-08 05:42:06
Subject: Re: [HACKERS] xlog.c.patch for cygwin port.
Previous:From: The Hermit HackerDate: 2000-03-08 05:19:24
Subject: Re: [HACKERS] 'LIKE' enhancement suggestion

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