String Escaping in Pattern Matching

From: Matthew <mboehm(at)voilaip(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: String Escaping in Pattern Matching
Date: 2007-08-27 22:29:02
Message-ID: 46D3502E.3040308@voilaip.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey gang,
I have three possible inputs:

18005551212
+18005551212
8005551212

Right now I am using this to strip off the +, 1, or +1:

INSERT INTO ... VALUES(SUBSTRING(usernumber FROM '^\\+?1?(.*)'));

This works perfect but I get all of these in the log:

WARNING: nonstandard use of \\ in a string literal at character 181

If I change to this as per the doc example right above the 9.7.3 header
on this page:
http://www.postgresql.org/docs/8.2/static/functions-matching.html

SUBSTRING(usernumber FROM '^#+?1?(.*)' FOR '#')

I get NULL inserted but no WARNING's.

A point if the right direction would be appreciated.

Thanks,
Matthew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-27 22:34:02 Re: simple query runs 26 seconds
Previous Message Erik Jones 2007-08-27 22:22:40 Re: Tables dissapearing