- Feature Request - ilike transformation

I don't know if this would be possible in the ODBC layer, but it would be=
nice if the ODBC driver
had a parameter that could be set to transform all LIKE predicates to ILI=
KE before the query is
processed by the server. =20

Currently, my users are accustomed to the behavior of LIKE in case insens=
itive databases, and are
not happy when I change LIKE's behavior to be case sensitive after portin=
g the back-end to
PostgreSQL.

In some cases where case insensitivity was absolutely needed now, I instr=
ucted the users to try:

'*[Aa]*[Ll][Oo][Tt]*[Oo][Ff]*[Ss]quare*brackets*'

but this doesn't go over to well. :o)

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster