No result but the matching data is available in table -----Original Message----- From: Heikki Linnakangas [mailto:[EMAIL PROTECTED] 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. > > 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 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
