Re: problem with regexp (cant quote +)]

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: problem with regexp (cant quote +)]
Date: 2003-07-05 20:34:19
Message-ID: 3F07364B.80804@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Peter,

peter pilsl wrote:
>
> postgres 7.3.2:
>
> I wonder why the following expression fails. I came to this wondering why I
> could not search for + using the '~'-operator.
>
> select 'ok' where 'H+H'~'H\+H';
>

funny. but try

select 'ok' where 'H+H' ~ 'H[+]H';

Regards
Tino

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2003-07-05 20:53:34 Re: problem with regexp (cant quote +)
Previous Message Grega Bremec 2003-07-05 16:39:37 Re: PostgreSQL vs. MySQL