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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2001-03-21 22:32:48 | Re: Encoding problem |
Previous Message | Peter Eisentraut | 2001-03-21 19:19:20 | Re: Doc bug: libpq PQconnectPoll() |