X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 1C62A9FA5CE for ; Wed, 30 Aug 2006 13:24:03 -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 35807-08 for ; Wed, 30 Aug 2006 16:23:57 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.229]) by postgresql.org (Postfix) with ESMTP id 6B2FC9FA4A5 for ; Wed, 30 Aug 2006 13:23:31 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so276647wxc for ; Wed, 30 Aug 2006 09:23:30 -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=WAlVIHp7uoCF64lErX71rSlvOHjTWlQb6nr9lVr6TEEKngjymWr3B+Gues85Ek9ot3642F810SYsLak/3K9IKyZnEFdvCV7GnDIx95mECmDgIvC3fjZLBXNtyZiISo9ItHlIYwmXNEuGCGpEnQJz+c/TzSNFp294ID5NU5xzVeE= Received: by 10.70.67.10 with SMTP id p10mr948738wxa; Wed, 30 Aug 2006 09:23:30 -0700 (PDT) Received: by 10.70.73.10 with HTTP; Wed, 30 Aug 2006 09:23:30 -0700 (PDT) Message-ID: <1d219a6f0608300923x4fb62e15t3fd6edcf2d337911@mail.gmail.com> Date: Wed, 30 Aug 2006 12:23:30 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: Re: How to convert a string to bytea? In-Reply-To: <1d219a6f0608300922s5c85649ci4ebfb8564fc5eacb@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_41128_12471661.1156955010081" References: <1d219a6f0608300922s5c85649ci4ebfb8564fc5eacb@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.696 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/331 X-Sequence-Number: 22874 ------=_Part_41128_12471661.1156955010081 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry, this was supposed to go to the -general list. On 8/30/06, Chris Hoover 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 > ------=_Part_41128_12471661.1156955010081 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry, this was supposed to go to the -general list.

On 8/30/06, Chris Hoover <revoohc@gmail.com> 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

------=_Part_41128_12471661.1156955010081--