Work Around For Simple Oracle interMedia?

From: "David Griffiths" <dgriffiths(at)boats(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Work Around For Simple Oracle interMedia?
Date: 2002-02-12 22:25:36
Message-ID: a4c4re$1c5h$1@jupiter.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One of our two databases uses context indexes on a column.

If your not familiar, this is part of the Oracle interMedia option. The idea
here is to be able to search for words within a text block. The text block
is in a row, in one of the columns. It can also be HTML, a Word document,
etc. When you index the column, it speeds up finding matching words.

Once that's done, you can search like this:

SELECT SCORE(1) title FROM news_items
WHERE CONTAINS(text, 'Bolivia', 1) > 0;

This would find all rows in the table "news_item" that has the text
"Bolivia" in the "title" column.

SELECT SCORE(1) title FROM news_items
WHERE CONTAINS(text, 'Bolivia OR Peru', 1) > 0;

This would find all rows in the table "news_item" that has the text
"Bolivia" or "Peru" in the "title" column in any order.

This is the most basic usage of the interMedia (you can get it to do a
soundex to match a sound, or get a "near" match or fuzzy match rather than
an exact match, etc.)

But I'm looking for the basic "return all rows where the text in this column
returns this word or these words".

My two thoughts are, write my own function in PERL, or store the text in a
file outside the database and use some OS-features to do the search

Any suggestions?

David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Copeland 2002-02-12 23:11:04 Re: [GENERAL] Feature enhancement request : use of libgda in
Previous Message Jeff Self 2002-02-12 21:00:54 Re: First time installer !!