Skip site navigation (1) Skip section navigation (2)

Re: regcomp problems

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Romolo Manfredini <romolo(at)bicnet(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: regcomp problems
Date: 2001-03-21 20:33:22
Message-ID: Pine.BSF.4.21.0103211230530.36201-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, 21 Mar 2001, Romolo Manfredini wrote:

> Dear postgresql developers,
> I have found a small annoying bug in the SQL parser,
> 
> executing the following query;
> 
> select * from table where field ~* '*';
> 
> or 
> 
> select * from table where field ~* '+';
> 
> generate the following error:
> 
> regcomp failed with error repetition-operator operand invalid 
> 
> the postgres I'm using is 7.0.3 compiled on linux 2.2.18

You're doing a regexp, both * and + have special meanings
in a regexp, you'll probably want to escape them (unfortunately
I think you need two backslashes to do it)


In response to

pgsql-bugs by date

Next:From: Tatsuo IshiiDate: 2001-03-21 22:32:48
Subject: Re: Encoding problem
Previous:From: Peter EisentrautDate: 2001-03-21 19:19:20
Subject: Re: Doc bug: libpq PQconnectPoll()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group