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

Re: BUG in REGULAR EXPRESSION

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>
Cc: "Theo Dickinson" <Theo(dot)Dickinson(at)unv(dot)org>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: BUG in REGULAR EXPRESSION
Date: 2004-05-06 14:51:47
Message-ID: 03AF4E498C591348A42FC93DEA9661B889FC8D@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
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(dot)Dickinson(at)unv(dot)org] 
> Sent: 04 May 2004 19:10
> To: 'pgadmin-support(at)postgresql(dot)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
> 

Responses

  • unsubscribe at 2004-05-06 18:24:37 from Alaric Dailey

pgadmin-support by date

Next:From: Alaric DaileyDate: 2004-05-06 18:24:37
Subject: unsubscribe
Previous:From: Theo DickinsonDate: 2004-05-04 18:10:12
Subject: BUG in REGULAR EXPRESSION

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