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