From: Mario Splivalo <mario.splivalo@mobart.hr>
To: pgsql-sql@postgresql.org
Subject: Re: Regular Expression Matching problem...
Date: Mon, 09 Jan 2006 02:22:49 +0100
Message-ID: <1136769769.19539.2.camel@localhost.localdomain> (raw)
In-Reply-To: <20060104170031.GB18628@winnie.fuhr.org>
References: <1136383726.8868.27.camel@localhost.localdomain>
<20060104145030.GG3490@webserv.wug-glas.de>
<20060104170031.GB18628@winnie.fuhr.org>
On Wed, 2006-01-04 at 10:00 -0700, Michael Fuhr wrote:
> What Andreas is saying is that the patterns in the table have too
> many backslashes. The original query was
>
> test=> select '+385911234567' ~ '^\\+38591\\d{7}$';
> ?column?
> ----------
> t
> (1 row)
>
> but if you select just the pattern you get
>
> test=> select '^\\+38591\\d{7}$';
> ?column?
> ----------------
> ^\+38591\d{7}$
> (1 row)
I was a bit silly here. Dunno why I tought I need to escape the
backslashes when entering regexp as data in table. Thank you for
pointing that out.
Mike
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mario.splivalo@mobart.hr
Subject: Re: Regular Expression Matching problem...
In-Reply-To: <1136769769.19539.2.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox