X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8E8A19FA4A5 for ; Wed, 30 Aug 2006 13:22:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49927-07 for ; Wed, 30 Aug 2006 13:22:19 -0300 (ADT) 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 6E3D89FA435 for ; Wed, 30 Aug 2006 13:22:19 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so276288wxc for ; Wed, 30 Aug 2006 09:22:18 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=jEq4orGVyYva3JijBKZs+IT4qJ+JKIeAgIijw7pq/tp3gg2lXnDCcmCk+hcZmrPbC9KwDOtfdyX7wMSnXEVTgApbk7VBoD2jgCUfz+A3GvXCI/Cw/qh098pOvP5BriMVFRRzTlNO48fmP+0j/lrVvG3AI1eSYqTfnf684jPzrjI= Received: by 10.70.19.20 with SMTP id 20mr968674wxs; Wed, 30 Aug 2006 09:22:18 -0700 (PDT) Received: by 10.70.73.10 with HTTP; Wed, 30 Aug 2006 09:22:18 -0700 (PDT) Message-ID: <1d219a6f0608300922s5c85649ci4ebfb8564fc5eacb@mail.gmail.com> Date: Wed, 30 Aug 2006 12:22:18 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: How to convert a string to bytea? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_41084_29756554.1156954938299" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.034 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_10_20, HTML_MESSAGE, RCVD_IN_BL_SPAMCOP_NET, SPF_PASS X-Spam-Level: ** X-Archive-Number: 200608/330 X-Sequence-Number: 22873 ------=_Part_41084_29756554.1156954938299 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_41084_29756554.1156954938299 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_41084_29756554.1156954938299--