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.

__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Mon, 29 Jan 2001 18:54:01 -0800 (PST)
m w <mttf2000@yahoo.com>
Like vs '='
Hi there,

   I am compiling postgresql 7.1beta4. How would i change the default 8k
row limit? 

-- 
                              Manny C. Cabido
                              ====================================
                              e-mail:manny@tinago.msuiit.edu.ph
                                     manny@sun.msuiit.edu.ph
                              =====================================


Tue, 30 Jan 2001 11:18:45 +0800 (PHT)
Manuel Cabido <manny@msuiit.edu.ph>
Re: Like vs '='
There isn't any row or query size limit in 7.1 thanks to TOAST! 

-Mitch


----- Original Message ----- 
From: "Manuel Cabido" <manny@msuiit.edu.ph>
To: "m w" <mttf2000@yahoo.com>
Cc: <pgsql-hackers@postgresql.org>
Sent: Monday, January 29, 2001 10:18 PM
Subject: Re: Like vs '='


> Hi there,
> 
>    I am compiling postgresql 7.1beta4. How would i change the default 8k
> row limit? 
> 
> -- 
>                               Manny C. Cabido
>                               ====================================
>                               e-mail:manny@tinago.msuiit.edu.ph
>                                      manny@sun.msuiit.edu.ph
>                               =====================================
> 
> 


Mon, 5 Feb 2001 13:00:44 -0500
"Mitch Vincent" <mitch@venux.net>
Re: Like vs '='