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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-05-06 14:51:47 | Re: BUG in REGULAR EXPRESSION |
Previous Message | Elvis E. Henriquez A. | 2004-05-04 10:52:09 | Re: Bug report |