Re: BUG #2204: Feature Req: Unique output column names - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #2204: Feature Req: Unique output column names
Date
Msg-id 20060124155245.GI25140@surnet.cl
Whole thread Raw
In response to BUG #2204: Feature Req: Unique output column names  ("Brandon Black" <blblack@gmail.com>)
Responses Re: BUG #2204: Feature Req: Unique output column names
List pgsql-bugs
Brandon Black wrote:

> I realize this is fixable by the user with "AS count_x", this is more an
> issue that came in writing cross-vendor ORM modules in perl, where most
> other database vendors offer some sort of unique naming convention, but
> postgres' output column names are indistinguishable, for the same query.

Use the AS clause, which is the one that actually complies with the SQL
standard.  Or show us where the standard mandates name munging and we
will implement it.

--
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2205: Compilation error on Tru64: socklen_t in pqcomm.c
Next
From: Tom Lane
Date:
Subject: Re: BUG #2206: error on declare cursor after a close cursor