Skip site navigation (1) Skip section navigation (2)

Re: BUG #3394: Partial search not working

From: "Murali Doss" <Murali(dot)Doss(at)mphasis(dot)com>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3394: Partial search not working
Date: 2007-06-19 09:25:07
Message-ID: 7C83A8A6B56D3A478333B1DF47E18586B92F1E@mpbabgex01.corp.mphasis.com (view raw or flat)
Thread:
Lists: pgsql-bugs
No result but the matching data is available in table

-----Original Message-----
From: Heikki Linnakangas [mailto:hlinnaka(at)gmail(dot)com] On Behalf Of Heikki
Linnakangas
Sent: Tuesday, June 19, 2007 1:17 PM
To: Murali Doss
Cc: pgsql-bugs(at)postgresql(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Murali DossDate: 2007-06-19 09:43:14
Subject: BUG #3395: varchar[] --> Warning vendor specific
Previous:From: Zdenek KotalaDate: 2007-06-19 07:50:56
Subject: Re: BUG #3394: Partial search not working

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group