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

Re: t1.col like '%t2.col%'

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Gregory Williamson" <Gregory(dot)Williamson(at)digitalglobe(dot)com>
Cc: "Dan Kaplan" <dkaplan(at)citizenhawk(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: t1.col like '%t2.col%'
Date: 2008-03-01 01:39:10
Message-ID: 20080229173910.5645c6e2@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 29 Feb 2008 17:30:08 -0700
"Gregory Williamson" <Gregory(dot)Williamson(at)digitalglobe(dot)com> wrote:

> Joshua Drake spake thusly:

> We used the now deprecated Full Text Indexing (FTI) with some
> handwaving. But that was in PostgreSQL 7.4 and FTI is not in the
> contrib package for some time now. See
> <http://pgfoundry.org/projects/simplefti/> ... I looked at using it
> in 8.1 but my "C" chops weren't up to it, and it depended heavily on
> OIDs which we didn't want to use. Anyway, our business requirement
> evaporated so it doesn't matter to us now.
> 

Right but wouldn't this be solved with tsearch2 and pg_tgrm?

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHyLO+ATb/zqfZUUQRAnRlAJ0S0jrc4pSmnBcobEtZvuDkpkWzIACcDP1t
Cwk/j1C2pEXWdANsyZV5f8E=
=9GYn
-----END PGP SIGNATURE-----

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2008-03-01 02:10:47
Subject: Re: t1.col like '%t2.col%'
Previous:From: Shane AmblerDate: 2008-03-01 00:44:09
Subject: Re: 12 disks raid setup

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