Re: REGEXP_REPLACE woes - Mailing list pgsql-general

From Leif B. Kristensen
Subject Re: REGEXP_REPLACE woes
Date
Msg-id 200806101909.27379.leif@solumslekt.org
Whole thread Raw
In response to Re: REGEXP_REPLACE woes  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On Tuesday 10. June 2008, Michael Fuhr wrote:

>Something between my message and your shell appears to have converted
>a few spaces to no-break spaces.  A hex dump of your query shows the
>following:
>
>00000000  73 65 6c 65 63 74 20 72  65 67 65 78 70 5f 72 65  |select
> regexp_re| 00000010  70 6c 61 63 65 28 0a c2  a0 20 c2 a0 27 5b 70 3d
>  |place(.   '[p=|
>
>Notice the byte sequences "c2 a0", which is the UTF-8 encoding of
><U+00A0 NO-BREAK SPACE>.  Apparently psql doesn't like that.  I don't
>see that sequence in my original message:

It's probably a KMail bug, or more likely a Qt or KDE library bug. IIRC
there was a similar bug in KNode some years ago when i tried to copy
and paste some Python code from a news discussion.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [ANNOUNCE] PostgreSQL Software Catalogue
Next
From: David Wall
Date:
Subject: Large objects oids