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

BUG in REGULAR EXPRESSION

From: Theo Dickinson <Theo(dot)Dickinson(at)unv(dot)org>
To: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: BUG in REGULAR EXPRESSION
Date: 2004-05-04 18:10:12
Message-ID: 8A2F0F003B4A7647A8F25E2B5732BD6AC4A899@exchange.unv.org (view raw or flat)
Thread:
Lists: pgadmin-support
Hello there

Im using pgadmin 1.0.2 for windows, postgresql 7.3.2 on redhat linux version
9.

If its any use to you when viewing a the sql for a view that works correctly
Ive noticed a space creeps in (in the example between the + and the )  
As you know this makes a difference in reg exp.

example
SELECT "substring"((h.url )::text, 'ass_id=([0-9]+ )'::text) AS ass_id,

it should be
SELECT "substring"((h.url )::text, 'ass_id=([0-9]+)'::text) AS ass_id,

Ive verified is wasnt something wrong with the db as other tools dont show
this SPACE CREEP.

Hope it helps you

Thanks for a great product



pgadmin-support by date

Next:From: Dave PageDate: 2004-05-06 14:51:47
Subject: Re: BUG in REGULAR EXPRESSION
Previous:From: Elvis E. Henriquez A.Date: 2004-05-04 10:52:09
Subject: Re: Bug report

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