Thread: BUG in REGULAR EXPRESSION

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

Hi Andreas,

I believe this problem originates in your reformatting code in
pgRuleObject::GetFormattedDefinition(). Can you take a look please - I
think it would take any of the rest of us a fair while to get our heads
around that function.

Cheers, Dave.

PS. Did you get a chance to look at the modified frmQuery I sent you?

> -----Original Message-----
> From: Theo Dickinson [mailto:Theo.Dickinson@unv.org]
> Sent: 04 May 2004 19:10
> To: 'pgadmin-support@postgresql.org'
> Subject: [pgadmin-support] BUG in REGULAR EXPRESSION
>
> 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
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>