| From: | "Zeugswetter Andreas ADI SD" <Andreas(dot)Zeugswetter(at)s-itsolutions(dot)at> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Josh Berkus" <josh(at)agliodbs(dot)com> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SQL feature requests |
| Date: | 2007-08-25 19:06:19 |
| Message-ID: | E1539E0ED7043848906A8FF995BDA579024F4859@m0143.s-mxs.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > I still don't see it as terrifically useful functionality, given
that it's
> > just saving you 4 keystrokes ...
>
> Less than that, because the AS is optional. The only argument I've
> heard that carries much weight with me is that it eases porting from
> other DBMS's that allow this. Are there any others besides Oracle?
FWIW IBM implemented this syntax in Informix 11.1 Cheetah released in
July 2007.
They also allow to omit the alias, and it imho makes sense.
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-25 19:08:19 | pgsql: Fix brain fade in DefineIndex(): it was continuing to access the |
| Previous Message | Steve Atkins | 2007-08-25 19:02:18 | Re: Best implementation of PATRICIA |