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/