Help on phrasee matching in WHERE (colum~*'.*ab*.') - Mailing list pgsql-novice

From Gabor Szilagyi
Subject Help on phrasee matching in WHERE (colum~*'.*ab*.')
Date
Msg-id 3AA7DA57.1030402@nyo.unep.org
Whole thread Raw
Responses Re: Help on phrasee matching in WHERE (colum~*'.*ab*.')
List pgsql-novice
Hi,

I am running PostgreSQL 7.0.3 on a Linux 2.4.0 using PHP4 (that is might
not relevant here).

What I am running into is this.

I am trying to pick out rows from the database which contains a
particular string.

I am using the following

SELECT * FROM in_table WHERE n_from ~* '.*nb*.

(Well actually a bunch of this condition is AND/OR -ed together)

My trouble is this: If I enter only a two character string as above,
it will not only matches string containing "nb" but all those which
contains the letter "n".

I tried this even with pgaccess directly !!! Same thing, is this a bug?

It is _very_ important for met to be able to match words containing
same strings including the two character variety ...

The above behaivour is just doesn't cut it..

Any suggestion would be welcomed

Gabor Szilagyi
szilagyi@nyo.unep.org


pgsql-novice by date:

Previous
From: "Mark, Terry"
Date:
Subject: pg_dump & BLOBs ?
Next
From: brew@theMode.com
Date:
Subject: pg_dump & BLOBs ?