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 need
or do I need to convert 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
> Sub
-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:
"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
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
