X-Original-To: pgsql-general-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id E70609FA666 for ; Wed, 30 Aug 2006 13:22:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 35820-03 for ; Wed, 30 Aug 2006 16:22:48 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234]) by postgresql.org (Postfix) with ESMTP id 397409FA4A5 for ; Wed, 30 Aug 2006 13:22:48 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so276288wxc for ; Wed, 30 Aug 2006 09:22:47 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=PwMhRp7/Bs3oxxY+1zc5AlIhASj7q0cLHddhbj60iJLRjMlfe6/ZY0vNJeBGhzE2BRSSTA69kpDUOdM8xmpFNGx+GjXTAr+Hw/V4lKnuLS+kSIgcMhOLwh+kF3rq+JpASxI1ZAu7ej4sw8ZINIaOxcKhizOoWRl+mvJzBjY0Cxg= Received: by 10.70.33.10 with SMTP id g10mr948094wxg; Wed, 30 Aug 2006 09:22:47 -0700 (PDT) Received: by 10.70.73.10 with HTTP; Wed, 30 Aug 2006 09:22:47 -0700 (PDT) Message-ID: <1d219a6f0608300922s6a0a4fcdy120de8044febf0a@mail.gmail.com> Date: Wed, 30 Aug 2006 12:22:47 -0400 From: "Chris Hoover" To: pgsql-general@postgresql.org Subject: Fwd: How to convert a string to bytea? In-Reply-To: <1d219a6f0608300922s5c85649ci4ebfb8564fc5eacb@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_41096_7018626.1156954967693" References: <1d219a6f0608300922s5c85649ci4ebfb8564fc5eacb@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.254 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, RCVD_IN_BL_SPAMCOP_NET, SPF_PASS X-Spam-Level: ** X-Archive-Number: 200608/1370 X-Sequence-Number: 100141 ------=_Part_41096_7018626.1156954967693 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline ---------- Forwarded message ---------- From: Chris Hoover Date: Aug 30, 2006 12:22 PM Subject: How to convert a string to bytea? To: "pgsql-admin@postgresql.org" 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 ------=_Part_41096_7018626.1156954967693 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

---------- Forwarded message ----------
From: Chris Hoover <revoohc@gmail.com>
Date: Aug 30, 2006 12:22 PM
Subject: How to convert a string to bytea?
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>

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
------=_Part_41096_7018626.1156954967693--