On 2011-01-24, Geoffrey Myers <li...@serioustechnology.com> wrote: > Massa, Harald Armin wrote: > > This does not work for me, but if I convert the hex value to octal this > does work: > > select comments from fax where comments ~* E'\231'; >
you can do hex like this: select comments from fax where comments ~* E'\x99'; or if your hex is unicode select comments from fax where comments ~* U&'\2122'; http://www.postgresql.org/docs/8.4/static/sql-syntax-lexical.html -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general