seiliki@xxxxxxxxxxxxx writes: > 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; > ERROR: invalid byte sequence for encoding "UTF8": 0x00 The reason that doesn't work is that E'\000' is initially a text literal, with the backslash sequence being processed by the string literal parser; and a zero byte isn't allowed in text. Try it with E'\\000'. What this gives rise to is a text constant containing the four characters \ 0 0 0, and then when that gets converted to bytea, another round of backslash processing will happen to produce the (legal) bytea constant with a single zero byte. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
