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

Re: like/ilike improvements

From: db(at)zigo(dot)dhs(dot)org
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>,"PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: like/ilike improvements
Date: 2007-05-23 05:55:04
Message-ID: 43311.192.121.104.48.1179899704.squirrel@zigo.dhs.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
> And Dennis said:
>
>> It is only when you have a pattern like '%_' when this is a problem
>> and we could detect this and do byte by byte when it's not. Now we
>> check (*p == '\\') || (*p == '_') in each iteration when we scan over
>> characters for '%', and we could do it once and have different loops
>> for the two cases.
>
> That's pretty much what the patch does now - It never tries to match a
> single byte when it sees "_", whether or not preceeded by "%".

My comment was about UTF-8 since I thought we were making a special
version for UTF-8. I don't know what properties other multibyte encodings
have.

/Dennis


In response to

pgsql-hackers by date

Next:From: NikhilSDate: 2007-05-23 06:15:41
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support
Previous:From: Shachar ShemeshDate: 2007-05-23 04:19:58
Subject: Re: Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server

pgsql-patches by date

Next:From: NikhilSDate: 2007-05-23 06:15:41
Subject: Re: CREATE TABLE LIKE INCLUDING INDEXES support
Previous:From: Andrew DunstanDate: 2007-05-22 22:37:24
Subject: Re: like/ilike improvements

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