Re: Help on phrasee matching in WHERE (colum~*'.*ab*.')
От | Rob Arnold |
---|---|
Тема | Re: Help on phrasee matching in WHERE (colum~*'.*ab*.') |
Дата | |
Msg-id | 005101c0ab64$e375c780$4200fd0a@home обсуждение исходный текст |
Ответ на | Help on phrasee matching in WHERE (colum~*'.*ab*.') (Gabor Szilagyi <Gabor.Szilagyi@nyo.unep.org>) |
Список | pgsql-novice |
It's acting correctly. The * means match 0 or more b's Rewrite it as '.*nb+' the + means match one or more times. --rob ----- Original Message ----- From: "Gabor Szilagyi" <Gabor.Szilagyi@nyo.unep.org> To: <pgsql-novice@postgresql.org> Sent: Thursday, March 08, 2001 2:15 PM Subject: Help on phrasee matching in WHERE (colum~*'.*ab*.') > 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 по дате отправления: