| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-03-08 05:42:06 | Re: [HACKERS] xlog.c.patch for cygwin port. |
| Previous Message | The Hermit Hacker | 2000-03-08 05:19:24 | Re: [HACKERS] 'LIKE' enhancement suggestion |