| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radim Kolar | 2012-07-17 11:45:41 | Re: not fetching all query results |
| Previous Message | Craig Ringer | 2012-07-17 03:16:02 | Re: not fetching all query results |