Re: [HACKERS] Postgress case insensitive search on FreeBSD3.0

On Mon, 8 Mar 1999, Vadim Valiakhmetov wrote:

Subject: [HACKERS] Postgress case insensitive search on FreeBSD3.0

I have encountered strange behaviour of Postgresql-6.4.2 server
(installed on FreeBSD3.0 from distributive) when I was trying to do
case-insensitive search in simplest text table (without indexes)

Try to compile with unsigend chars, if the problem persists then you have
the same problem that I witnessed on BSDi.

You will need to manually edit regexp.c and cast all chars to unsigned chars
in all the pg_upper and pg_lower function calls.

--
Incredible Networks LTD Angelos Karageorgiou
20 Karea st, +30.1.92.12.312 (voice)
116 36 Athens, Greece. +30.1.92.12.314 (fax)
http://www.incredible.com angelos@incredible.com (e-mail)