Re: [ADMIN] How to convert a string to bytea?

[Markus Wollny]

On 8/30/06, Chris Hoover <[EMAIL PROTECTED]> wrote: 

>I am in need of some help.  I need to use the encode function 
> against a text string in one of my pg/plsql functions.  
> However, the encode function expects a bytea field to be 
> passed to it.  How do I convert my text string into a bytea? 
        
I use two simple plpgsql functions to convert strings to and from bytea:

CREATE OR REPLACE FUNCTION text2bytea(text)
  RETURNS bytea AS
$BODY$
begin
 return $1;
end;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;

and

CREATE OR REPLACE FUNCTION bytea2text(bytea)
  RETURNS text AS
$BODY$
begin
 return $1;
end;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;

Kind regards

   Markus

________________________________

Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Chris Hoover
Gesendet: Mittwoch, 30. August 2006 18:24
An: pgsql-admin@postgresql.org
Betreff: Re: [ADMIN] How to convert a string to bytea?


Sorry, this was supposed to go to the -general list.


On 8/30/06, Chris Hoover <[EMAIL PROTECTED]> wrote: 

        I am in need of some help.  I need to use the encode function
against a text string in one of my pg/plsql functions.  However, the
encode function expects a bytea field to be passed to it.  How do I
convert my text string into a bytea? 
        
        Thanks,
        
        
        Chris
        



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly