Re: Bytea question with \208

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 to convert the
> bit stream to octal numbers?

to_hex()?

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] 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" <george.woodring@iglass.net> 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 space map settings
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>

--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)