From: | Kevin Brown <kevin(at)sysexperts(dot)com> |
---|---|
To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Problem about pgsql's column alias |
Date: | 2003-04-15 00:35:18 |
Message-ID: | 20030415003518.GZ1833@filer |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-interfaces pgsql-jdbc |
Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > Tom Lane writes:
> >> AS is not optional in Postgres, and will never be so unless we choose to
> >> drop support for postfix operators, which I consider an unlikely choice.
>
> > Well, we could drop the support for postfix operators in aliasing clauses
> > that omit the AS.
>
> I think it would be a bad idea in any case; it would mask errors too
> easily. For example, you meant to say "SELECT a + b, ..." but wrote
> "SELECT a b, ...". Or how about this:
> SELECT 'foo'::character varying
> Is "varying" an alias or part of the type name?
Shouldn't we be deprecating the use of :: in favor of the SQL-standard
CAST()?
--
Kevin Brown kevin(at)sysexperts(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2003-04-15 00:38:05 | Re: Are we losing momentum? |
Previous Message | Kevin Brown | 2003-04-15 00:30:27 | Re: Are we losing momentum? |
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2003-04-15 00:38:05 | Re: Are we losing momentum? |
Previous Message | Bruce Badger | 2003-04-15 00:33:29 | Tuning heuristics |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-15 05:49:26 | Re: [GENERAL] Problem about pgsql's column alias |
Previous Message | Michiel Lange | 2003-04-14 17:11:52 | Re: [INTERFACES] Problem in installing the PgAdminII in Window |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-15 05:49:26 | Re: [GENERAL] Problem about pgsql's column alias |
Previous Message | Nic Ferrier | 2003-04-14 22:51:06 | refcursor handling patch |