SQL repr of bytea val

From: Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL repr of bytea val
Date: 2005-06-20 13:47:01
Message-ID: 1119275221.4688.14.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I'm constructing querys on the fly in PL/pgSQL_ and need a function that
returns the SQL representation of a bytea value. I tried encode(..,
'escape') but it seems to return 8 bit ASCII values, not the \377 stuff
that's supposed to be in the bytea input syntax. Does anyone know a way
to do that?

Markus

--
Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message grupos 2005-06-20 16:31:20 Array in plpgsql with composite type
Previous Message Theodore Petrosky 2005-06-20 12:29:03 Re: info