> > 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@alumni.caltech.edu
South Pasadena, California