Re: bytea question

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.