Skip site navigation (1) Skip section navigation (2)

Re: Case-sensitive problem in AS clause?

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: dmp <danap(at)ttc-cmc(dot)net>, David Johnston <polobo(at)yahoo(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Case-sensitive problem in AS clause?
Date: 2012-07-17 03:20:31
Message-ID: 5004D9FF.7070002@ringerc.id.au (view raw or flat)
Thread:
Lists: pgsql-jdbc
On 07/17/2012 02:48 AM, Dave Cramer wrote:
> Ok, I just looked up the tutorial and it really is whether the value
> stored in the column is case sensitive, not the name of the column.
>
> Yet another serious ambiguity in the API spec.

Yay, won't THAT be fun to implement when Pg its self doesn't know 
whether any given type is case-sensitive or not (eg 'text' vs 'citext') 
and doesn't have the concept of per-column case sensitivity at all.

What's the right thing to return here? True unless 'citext'?

--
Craig Ringer

In response to

pgsql-jdbc by date

Next:From: Radim KolarDate: 2012-07-17 11:45:41
Subject: Re: not fetching all query results
Previous:From: Craig RingerDate: 2012-07-17 03:16:02
Subject: Re: not fetching all query results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group