Re: case-(in)sensitive Server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: Daniel Grob <dgrob(at)gmx(dot)net>, pgsql-novice(at)postgresql(dot)org
Subject: Re: case-(in)sensitive Server
Date: 2002-06-13 20:48:42
Message-ID: 29476.1024001322@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Josh Berkus <josh(at)agliodbs(dot)com> writes:
> He wants
> SELECT * FROM table_a WHERE code = 'volume';
> to be automagically replaced with:
> SELECT * FROM table_a WHRE code ILIKE 'volume';

I don't see any way we could do that at the server level without causing
*all* text = operations to work that way; which almost inevitably would
break something.

Given that the client-side code is open source, I would think that a
client-side solution would be no harder to make happen, and it'd surely
be a lot cleaner.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-06-13 21:03:15 Re: case-(in)sensitive Server
Previous Message Josh Berkus 2002-06-13 20:42:27 Re: case-(in)sensitive Server