> > 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 Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California
In response to
pgsql-hackers by date
|Next:||From: The Hermit Hacker||Date: 2000-03-08 05:42:06|
|Subject: Re: [HACKERS] xlog.c.patch for cygwin port.|
|Previous:||From: The Hermit Hacker||Date: 2000-03-08 05:19:24|
|Subject: Re: [HACKERS] 'LIKE' enhancement suggestion|