Postgres Pro
Downloads
Home   >   mailing lists

Re: Work Around for Oracle Context Indexes? - Mailing list pgsql-general

From dalgoda@ix.netcom.com (Mike Castle)
Subject Re: Work Around for Oracle Context Indexes?
Date
Msg-id 5cnr4a.n6a.ln@thune.mrc-home.org
Whole thread Raw
In response to Work Around for Oracle Context Indexes?  ("David Griffiths" <dgriffiths@boats.com>)
List pgsql-general
Tree view 
In article <200202181429.g1IETjP12439@candle.pha.pa.us>,
Bruce Momjian  <pgman@candle.pha.pa.us> wrote:
>Sure, see /contrib/fulltextindex.


Is this bit from README.fti still true:

(this can also be done by using subselects - but subselects are currently
inefficient in Postgres, and maybe there're other ways too).

If not, would it be better to use joins or sub-selects?

mrc
--
     Mike Castle      dalgoda@ix.netcom.com      www.netcom.com/~dalgoda/
    We are all of us living in the shadow of Manhattan.  -- Watchmen
fatal ("You are in a maze of twisty compiler features, all different"); -- gcc

pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: Re: Sum of events over an interval; how?
Next
From: Justin Clift
Date:
Subject: Second decent PostgreSQL CBT released - Introduction to Referential Integrity