Re: [GENERAL] Problem about pgsql's column alias

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: milimeter(at)163(dot)com, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] Problem about pgsql's column alias
Date: 2003-04-15 13:24:11
Message-ID: Pine.LNX.4.44.0304151046520.1750-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-interfaces pgsql-jdbc

Tom Lane writes:

> 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?

That seems like a rather poor excuse for not supporting a standard feature
that people seem to ask about every week. If someone can't tell the
difference between a and a + b he's going to have more problems than this.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jay O'Connor 2003-04-15 13:36:51 Appending to an array
Previous Message Shridhar Daithankar 2003-04-15 13:18:46 Re: [GENERAL] Are we losing momentum?

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:38:46 qualified column names
Previous Message Shridhar Daithankar 2003-04-15 13:18:46 Re: [GENERAL] Are we losing momentum?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:38:46 qualified column names
Previous Message Tom Lane 2003-04-15 05:49:26 Re: [GENERAL] Problem about pgsql's column alias

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-04-15 13:38:46 qualified column names
Previous Message Nic Ferrier 2003-04-15 11:33:14 Re: the build