Re: word search

From: Wim Ceulemans <wim(dot)ceulemans(at)nice(dot)be>
To: Cédric Prévost <cedric_prevost(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: word search
Date: 2000-04-04 07:41:43
Message-ID: 38E99CB7.C59E446C@nice.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Cédric Prévost" wrote:
>
> Hello,
>
> I would like to proceed to word search in a table.
> Use of "[...] attribute~*'string';" in the condition were fine. However,
> presence of operators within the string give me an error.
> For example :
> [...] attribute~*'C++';
> To unspecialise the operators could be a way of solving this.
> Do you know to do that, if it is possible ?
> Thanks for you help,
>

Make sure the result to the backend is:

[...] attribute ~* 'C\\+\\+';

(escape the special characters)

Wim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Richards 2000-04-04 08:30:17 Re: SELECT speed with LIKE
Previous Message Balazs Gyetvai 2000-04-04 06:57:02 Create user prob.