Escaping w/i regular expressions

From: Peter Eisentraut <peter(at)pathwaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Escaping w/i regular expressions
Date: 1999-06-30 18:07:26
Message-ID: Pine.LNX.4.10.9906301406440.30903-100000@uruguay.pathwaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How do you escape a ' (apostrophe) within a regular expression, so it does
not close off the string? Something like
... ~ '[0-9.,\']'
does not seem to work.
(Pgsql 6.4.2)

Any ideas?

--
Peter Eisentraut
PathWay Computing

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Bitmead 1999-07-01 02:13:35 Re: [SQL] Beginner's headache of joins
Previous Message Hostmaster - Internet au Virtuel Inc. 1999-06-30 17:07:01 User defined functions through ODBC