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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: Thursday, August 09, 2007 2:14 PM
> To: Woody Woodring
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Bytea question with \208
>
> "Woody Woodring" <george(dot)woodring(at)iglass(dot)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(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)