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: [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 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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
pgpFsLPGQCFcG.pgp
Description: PGP signature
