Обсуждение: SQL repr of bytea val

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>

On Mon, Jun 20, 2005 at 03:47:01PM +0200, Markus Bertheau ??? wrote:
> 
> 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?

How about textin(byteaout(bytea_value))?  Or a function that performs
the conversion by magic:

CREATE FUNCTION bytea2text(bytea) RETURNS text AS $$
BEGIN   RETURN $1;
END;
$$ LANGUAGE plpgsql IMMUTABLE STRICT;

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/