No result but the matching data is available in table
-----Original Message-----
From: Heikki Linnakangas [mailto:hlinnaka@gmail.com] On Behalf Of Heikki
Linnakangas
Sent: Tuesday, June 19, 2007 1:17 PM
To: Murali Doss
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #3394: Partial search not working
Murali Doss wrote:
> Partial search query is not working Linux OS with postgresql 8.2.4 but
the
> same is working fine in windows and solaris OS.
>=20
> I like to know whether i need to run some patch in linux OS to make
the
> partial search to work.
>=20
> SELECT * FROM tablename WHERE colname BETWEEN 'B-' AND 'B~' ORDER BY
> colname
What do you mean by "not working"? Does it give an error message?=20
Unexpected results?
Are you perhaps using a different locale on different platforms?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com