bytea hex input/output
От
Michael Artz
Тема
bytea hex input/output
Дата
Msg-id
1147810463.746249.14600@i39g2000cwa.googlegroups.com
Список
Дерево обсуждения
bytea hex input/output "Michael Artz" <mlartz@gmail.com>
Re: bytea hex input/output Tom Lane <tgl@sss.pgh.pa.us>
Re: bytea hex input/output "Michael Artz" <mlartz@gmail.com>
Re: bytea hex input/output Tom Lane <tgl@sss.pgh.pa.us>
Re: bytea hex input/output Bruce Momjian <pgman@candle.pha.pa.us>
Re: bytea hex input/output Tom Lane <tgl@sss.pgh.pa.us>
Silly little question, but is there something to input/output hex
escaped data into a bytea, ala
CREATE TABLE a (lob BYTEA);
INSERT into a (lob) VALUES ('\x01\x02\x00\x03\x04');
INSERT into a (lob) VALUES ('\x01\x00\x02\x00\x03\x04');
It seems to work (doesn't error), but when selecting the data back out,
it is truncated at the first \x00, ala
SELECT lob FROM a;
lob
----------
\001\002
\001
SELECT octet_length(lob) from a;
octet_length
--------------
2
1
Why does this happen? Also, can I get the output in similar hex form?
В списке pgsql-general по дате отправления