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

Re: [HACKERS] LIKE fixed(?) for non-ASCII collation orders

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Degert <ad(at)papyrus-gmbh(dot)de>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] LIKE fixed(?) for non-ASCII collation orders
Date: 1999-12-31 15:40:51
Message-ID: 18472.946654851@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Andreas Degert <ad(at)papyrus-gmbh(dot)de> writes:
> the .. >= .. < .. condition will result in addtional matches, like 'fo ot',
> so you still have to check with LIKE.

Of course.  The point of all this is just to create a "prefilter" that can
be implemented by scanning an index, so that most of the rows in the
table need not be visited at all when the LIKE pattern has the right
form.  But the original LIKE operator is still executed as part of the
WHERE condition for each row.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: The Hermit HackerDate: 1999-12-31 15:52:09
Subject: Re: [HACKERS] Happy New Year!
Previous:From: Sren KreimeierDate: 1999-12-31 15:17:55
Subject: How you can put over 20 GB on a single CD!

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