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 B1E809FB331 for ; Wed, 30 Aug 2006 16:56:31 -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 90519-04 for ; Wed, 30 Aug 2006 19:56:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from isis.sigpipe.cz (fw.sigpipe.cz [62.245.70.224]) by postgresql.org (Postfix) with ESMTP id BB0FE9FB323 for ; Wed, 30 Aug 2006 16:56:23 -0300 (ADT) Received: from dagan.sigpipe.cz (dagan.sigpipe.cz [10.9.8.90]) by isis.sigpipe.cz (Postfix) with ESMTP id 0325A1F87BFD; Wed, 30 Aug 2006 21:56:22 +0200 (CEST) Received: by dagan.sigpipe.cz (Postfix, from userid 1001) id 352802C92FD; Wed, 30 Aug 2006 21:56:50 +0000 (UTC) Date: Wed, 30 Aug 2006 21:56:50 +0000 From: Roman Neuhauser To: Chris Hoover Cc: pgsql-general@postgresql.org Subject: Re: Fwd: How to convert a string to bytea? Message-ID: <20060830215650.GC70552@dagan.sigpipe.cz> Mail-Followup-To: Chris Hoover , pgsql-general@postgresql.org References: <1d219a6f0608300922s5c85649ci4ebfb8564fc5eacb@mail.gmail.com> <1d219a6f0608300922s6a0a4fcdy120de8044febf0a@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1d219a6f0608300922s6a0a4fcdy120de8044febf0a@mail.gmail.com> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/1390 X-Sequence-Number: 100161 # revoohc@gmail.com / 2006-08-30 12:22:47 -0400: > ---------- 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? See decode()/encode() in http://www.postgresql.org/docs/8.1/static/functions-binarystring.html -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991