Subject: like vs '='

Subject: like vs '='

I have a function to transform text into a
pseudo-metaphone variable, take this
example:

cddbsql=# select song, metatext(song) from cdsongs
where metatext(song) like
metatext('born to run') limit 3 ;
song | metatext
-------------+----------
Born To Run | brntorn
Born To Run | brntorn
Born To Run | brntorn
(3 rows)

Here is the problem: Depending on whether there is
an index or not, 'like'
behaves differently. Here is a transcript:

cddbsql=# select song, metatext(song) from cdsongs
where metatext(song) like
metatext('born to run') limit 1 ;
song | metatext
-------------+----------
Born To Run | brntorn
(1 row)

cddbsql=# create index cdsongs_meta_song on cdsongs
(metatext(song)) ;
CREATE
cddbsql=# select song, metatext(song) from cdsongs
where metatext(song) like
metatext('born to run') limit 1 ;
song | metatext
------+----------
(0
rows)

This happens in both 7.0 and
7.1.
--
http://www.mohawksoft.com

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/