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.
I like to know whether i need to run some patch in linux OS to make the
partial search to work.
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?
Unexpected results?
Are you perhaps using a different locale on different platforms?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
