Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: gruposDate: 2005-06-20 16:31:20
Subject: Array in plpgsql with composite type
Previous:From: Theodore PetroskyDate: 2005-06-20 12:29:03
Subject: Re: info

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group