On Mon, 28 Sep 2009, Maximilian Tyrtania wrote: > testdb=# create table byteatest(blob bytea); > CREATE TABLE > testdb=# insert into byteatest (blob) values (E'\\007'); > INSERT 0 1 > testdb=# insert into byteatest (blob) values (E'\\008'); > ERROR: invalid input syntax for type bytea > LINE 1: insert into byteatest (blob) values (E'\\008'); > > Or also: > > testdb=# SELECT E'\\001'::bytea; > bytea > ------- > \001 > (1 row) > > testdb=# SELECT E'\\008'::bytea; > ERROR: invalid input syntax for type bytea > LINE 1: SELECT E'\\008'::bytea; > > As far as I can see i followed the escaping rules given in > > http://www.postgresql.org/docs/current/static/datatype-binary.html
>From that: "When entering bytea values, octets of certain values must be escaped (but all octet values can be escaped) when used as part of a string literal in an SQL statement. In general, to escape an octet, convert it into its three-digit octal value and precede it by two backslashes." 008 isn't a valid octal value, you'd want 010 to represent 8. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
