Received: from uruguay.pathwaynet.com (IDENT:exim@uruguay.pathwaynet.com [216.46.203.34]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA74867 for ; Wed, 30 Jun 1999 14:07:28 -0400 (EDT) (envelope-from peter@pathwaynet.com) Received: from peter (helo=localhost) by uruguay.pathwaynet.com with local-esmtp (Exim 3.00 #1) id 10zOla-0004lD-00 for pgsql-sql@postgresql.org; Wed, 30 Jun 1999 14:07:26 -0400 Date: Wed, 30 Jun 1999 14:07:26 -0400 (EDT) From: Peter Eisentraut To: pgsql-sql@postgresql.org Subject: Escaping w/i regular expressions Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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