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

Re: LIKE vs =

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: David Wheeler <david(at)kineticode(dot)com>,SF PostgreSQL Users <sfpug(at)postgresql(dot)org>
Subject: Re: LIKE vs =
Date: 2004-08-23 17:42:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: sfpug

> Any idea why = works here and LIKE wouldn't?

Yes.  I believe that LIKE relies on the database encoding, whereas = does a 
direct byte comparison.  However, I don't have much experience with encoding 
issues, so you might be better off asking someone else.

I also recall there there were problems with multi-byte LIKE still being 
worked on in 8.0.

One question, though, what do you get if you do:

bric=# select * from keyword where name ~ '^λΆν•œμ˜';

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

  • LIKE vs = at 2004-08-23 17:39:38 from David Wheeler


sfpug by date

Next:From: David FetterDate: 2004-08-23 17:46:20
Subject: Re: LIKE vs =
Previous:From: David WheelerDate: 2004-08-23 17:39:38
Subject: LIKE vs =

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