From: Alberto Cabello Sanchez <alberto@unex.es>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-interfaces@postgresql.org
Subject: Re: ColumnName and ColumnNumber in libpq (C interface)
Date: Wed, 17 Sep 2003 08:29:12 +0200
Message-ID: <20030917062912.GA5432@guadiana.unex.es> (raw)
In-Reply-To: <16696.1063719986@sss.pgh.pa.us>
References: <3F65715A.BDCAD1FB@rodos.fzk.de>
<10317.1063637327@sss.pgh.pa.us>
<20030916075640.GA10965@guadiana.unex.es>
<16696.1063719986@sss.pgh.pa.us>
On Tue, Sep 16, 2003 at 09:46:26AM -0400, Tom Lane wrote:
> I don't really want to change PQfname; that would probably break more
> apps than changing PQfnumber.
>
> We could achieve the property you suggest if we forgot about
> case-insensitive matching and dequoting, and simply made PQfnumber check
> for an exact match.
...but this is also app breaker.
>
> Or we could try some combination behavior (say, try exact match, then
> if no luck apply the dequote/downcase logic). This might offer better
> backwards compatibility, but the more complex the behavior, the more
> potential for surprising corner cases ...
>
What about a PQfrealname function (actually, a macro) which returns quoted
string? I hope this suggestion is not too stupid.
--
-----------------------
Alberto Cabello Sánchez
alberto@unex.es
Servicio de Informática
924 289 351
-----------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: alberto@unex.es, tgl@sss.pgh.pa.us
Subject: Re: ColumnName and ColumnNumber in libpq (C interface)
In-Reply-To: <20030917062912.GA5432@guadiana.unex.es>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox