Skip site navigation (1) Skip section navigation (2)

Re: bytea question

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Maximilian Tyrtania <maximilian(dot)tyrtania(at)byte-employer(dot)de>
Cc: 'PostgreSQL pg-general List' <pgsql-general(at)postgresql(dot)org>
Subject: Re: bytea question
Date: 2009-09-28 16:33:12
Message-ID: 20090928093020.U40526@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-general
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.

In response to

pgsql-general by date

Next:From: Merlin MoncureDate: 2009-09-28 16:42:13
Subject: Re: computed values in plpgsql
Previous:From: Adrian KlaverDate: 2009-09-28 16:31:30
Subject: Re: sync structures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group