Re: bytea hex input/output - Mailing list pgsql-general

From Michael Artz
Subject Re: bytea hex input/output
Date
Msg-id e9c163070605161756i5fb91221wa5e3e63d2fde0bc0@mail.gmail.com
Whole thread Raw
In response to Re: bytea hex input/output  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: bytea hex input/output  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Eh, I'll just convert it all to octal, I just thought that I could get away without any middleman.

What ig going on behind the scenes?  Does it first get converted to text and then on to bytea?  Would an explicit cast get around this (perhaps with associated UDF)?

-Mike

On 5/16/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Michael Artz" <mlartz@gmail.com> writes:
> Silly little question, but is there something to input/output hex
> escaped data into a bytea, ala

PQescapeBytea, perhaps?  The way you are doing it has multiple problems.

                        regards, tom lane

pgsql-general by date:

Previous
From: Sean Davis
Date:
Subject: Re: FATAL: could not read statistics message
Next
From: Kenneth Downs
Date:
Subject: Re: Announce: GPL Framework centered on Postgres