problem with regexp (cant quote +) - Mailing list pgsql-general

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';

thnx,
peter


--
IT-Consulting
mag. peter  pilsl
tel:+43-699-1-3574035
fax:+43-699-4-3574035
pilsl@goldfisch.at
http://www.goldfisch.at