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:[EMAIL PROTECTED] > Sent: 04 May 2004 19:10 > To: '[EMAIL PROTECTED]' > 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 > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])