On 2010-04-29, Justin Graf <jus...@magwerks.com> wrote:

> I'm pretty sure this is the regualr expression to find all non ASCII=20
> chars.. [^\x00-\xFF]

Not in postgres.

 \x00 does not work well in strings,  and \xFF is invalid utf-8.
 this is why I used char() 
 
(also ASCII is undefined past at \x7F ... but the original request
 was for LATIN-1 which does end at char(255))

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to