seiliki(at)so-net(dot)net(dot)tw wrote:
> Data type of table1.c1 is bytea. That column stores binary data. The
> following matchings do not work. What is the right syntax?
>
> TIA
> CN
> ---------------
> select c1 ~ E'\000' from table1;
> select c1 LIKE E'%\000%' from table1;
selection position(E'\\000'::bytea in c1) from table1;
The value is 0 when there is no match and >0 otherwise.
Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org