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

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

> > Jan, Tom, is there any way that he could do this with RULEs?  It seems
> > like there should be some way, but I can't figure it out.
>
> Do *what*, exactly?  It wasn't at all clear to me what SQL operation is
> being performed here.

He wants
SELECT * FROM table_a WHERE code = 'volume';
to be automagically replaced with:
SELECT * FROM table_a WHRE code ILIKE 'volume';

to build-in case insensitivity.

--
-Josh Berkus


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: case-(in)sensitive Server
Next
From: Tom Lane
Date:
Subject: Re: case-(in)sensitive Server