Im using pgadmin 1.0.2 for windows, postgresql 7.3.2 on redhat linux version
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.
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 Page||Date: 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|