Re: [GENERAL] Problem about pgsql's column alias - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [GENERAL] Problem about pgsql's column alias
Date
Msg-id Pine.LNX.4.44.0304151046520.1750-100000@peter.localdomain
Whole thread Raw
In response to Re: [GENERAL] Problem about pgsql's column alias  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses qualified column names  (Dave Cramer <dave@fastcrypt.com>)
Re: [GENERAL] Problem about pgsql's column alias  (Tom Lane <tgl@sss.pgh.pa.us>)
qualified column names  (Dave Cramer <dave@fastcrypt.com>)
List pgsql-hackers
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@gmx.net



pgsql-hackers by date:

Previous
From: Кузьмина-Вакилова Елена
Date:
Subject:
Next
From: Dave Cramer
Date:
Subject: qualified column names