Re: case-(in)sensitive Server - Mailing list pgsql-novice

From Tom Lane
Subject Re: case-(in)sensitive Server
Date
Msg-id 29476.1024001322@sss.pgh.pa.us
Whole thread Raw
In response to Re: case-(in)sensitive Server  (Josh Berkus <josh@agliodbs.com>)
Responses Re: case-(in)sensitive Server
List pgsql-novice
Josh Berkus <josh@agliodbs.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

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: case-(in)sensitive Server
Next
From: Josh Berkus
Date:
Subject: Re: case-(in)sensitive Server