Re: Request for qualified column names

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Reggie Burnett <rykr(at)bellsouth(dot)net>, "'Dave Cramer'" <dave(at)fastcrypt(dot)com>, "'PostgreSQL Hackers Mailing List'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Request for qualified column names
Date: 2003-01-27 21:14:52
Message-ID: 8037.1043702092@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> My idea on this after chat with Dave was to add a GUC option that puts
> the schema.table.column name as the default column label, rather than
> just the column name.

And will you quotify things so that names containing dots, spaces, etc
are unambiguous?

I think the above is a very poor substitute for doing it properly,
namely returning the values in separate fields. We should not allow
ourselves to get lured into a dead end just because we can do it without
obviously breaking the protocol. (I would argue that this breaks the
protocol anyway, though.)

> I am not overly excited
> about doing this at the protocol level unless there is major need for it.

I'm not excited about doing it at all, unless we do it right. We can
already have half-baked solutions on the client side ;-)

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-01-27 21:18:10 Re: Request for qualified column names
Previous Message Peter Eisentraut 2003-01-27 21:10:02 Re: Win32 port patches submitted