Postgres Pro
Downloads
Home   >   mailing lists

SQL repr of bytea val - Mailing list pgsql-sql

From Markus Bertheau ☭
Subject SQL repr of bytea val
Date
Msg-id 1119275221.4688.14.camel@dicaprio.akademie1.de
Whole thread Raw
Responses Re: SQL repr of bytea val  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Tree view 
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@bluetwanger.de>

pgsql-sql by date:

Previous
From: Theodore Petrosky
Date:
Subject: Re: info
Next
From: grupos
Date:
Subject: Array in plpgsql with composite type