PG 8.4.0 running on Mac OS 10.6.1
Could anyone tell me why the bytea datatypes seems to like some bytes better
than others?
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
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
Decibel! wrote:
On Thu, Aug 09, 2007 at 04:16:15PM -0400, Woody Woodring wrote:
My bad, the table I was looking (8.7) at had the first column as the
decimal representation and I did notice that the numbers changed as they
moved right.
Is there a way for bytea to take a hex number, or do I
Could someone explain why \208 is not a valid syntax for bytea?
I am getting the following:
test= select E'\\207'::bytea;
bytea
---
\207
(1 row)
test= select E'\\208'::bytea;
ERROR: invalid input syntax for type bytea
test= select E'\\209'::bytea;
ERROR: invalid input syntax for type
Woody Woodring [EMAIL PROTECTED] writes:
Could someone explain why \208 is not a valid syntax for bytea?
Aren't those escapes octal?
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, August 09, 2007 2:14 PM
To: Woody Woodring
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Bytea question with \208
Woody Woodring [EMAIL PROTECTED] writes:
Could someone explain
the
bit stream to octal numbers?
to_hex()?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, August 09, 2007 2:14 PM
To: Woody Woodring
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Bytea question with \208
Woody
Oops! You have to write a function for it. Here is a
sample quick C function:
typedef struct
{ int len;
char data[1];
} string;
string *byteatostr(bytea *arg)
{
char buf[1024];
int ln,i;
string *res;
ln = VARSIZE(arg) - VARHDRSZ;
memmove(buf,
Oops! You have to write a function for it. Here is a
sample quick C function:
typedef struct
{ int len;
char data[1];
} string;
string *byteatostr(bytea *arg)
{
char buf[1024];
int ln,i;
string *res;
ln = VARSIZE(arg) - VARHDRSZ;
memmove(buf,