I have been looking into the Postgresql 8 docs and noticed that they
have a varchar_pattern_ops operator class to help get around the problem
with like and non-C locales. I am trying to find out if there is any
thing like this in the 7.3 server since we are still a good 6+ months
from being able to roll out Postgresql 8.x.

Thanks,

Chris


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

"Chris Hoover" <revoohc@sermonaudio.com> writes:
> I have been looking into the Postgresql 8 docs and noticed that they
> have a varchar_pattern_ops operator class to help get around the problem
> with like and non-C locales. I am trying to find out if there is any
> thing like this in the 7.3 server since we are still a good 6+ months
> from being able to roll out Postgresql 8.x.

I believe that was added in 7.4, if you think moving to 7.4 would be
more feasible.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly