Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id AC6349FA23F
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 27 Nov 2006 12:10:50 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 04737-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 27 Nov 2006 12:10:43 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by postgresql.org (Postfix) with ESMTP id 6EAD89FA231
	for <pgsql-sql@postgresql.org>; Mon, 27 Nov 2006 12:10:42 -0400 (AST)
Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise;
	Mon, 27 Nov 2006 17:10:40 +0100
Message-Id: <456B1C07020000300000FC7F@webaccess.indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.1 
Date: Mon, 27 Nov 2006 17:10:31 +0100
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: <Markus Schaber <schabi@logix-tt.com>,
	<pgsql-sql@postgresql.org>
Cc: "Richard Huxton"<dev@archonet.com>
Subject: Re: UNICODE and PL/PGSQL
References: <456AD17A020000300000FB60@webaccess.indicator.be><1164638251.270
	70.45.camel@localhost.localdomain><456B0A47020000300000FC1E@webaccess.ind
	i	cator.be><456B0A47020000300000FC1E@webaccess.indicator.be><456B0153.30106
	03	@logix-tt.com><456B132F020000300000FC4B@webaccess.indicator.be><456B132F
	020000300000FC4B@webaccess.indicator.be><456B09DD.909@logix-tt.com>
In-Reply-To: <456B09DD.909@logix-tt.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__PartAC888FE7.2__="
X-imss-version: 2.044
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/265
X-Sequence-Number: 26917

--=__PartAC888FE7.2__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

I haven't got enough permissions to install new programs. Big brother... =
;-)
I get the error in a plpgsql function
I use PostgreSQL 8.1.4 with EMS SQL Manager 2005 (3.6.0.1).

>>> Markus Schaber <schabi@logix-tt.com> 2006-11-27 16:53 >>>

Hi, Bart,

Bart Degryse wrote:

> I should have said "The ICT department doesn't give me access to the
> psql command line interface".

Hmm, and you can't install psql on the same host you use to run pgadmin?

It's just a client, that connects to PostgreSQL the same way as pgamdin.


> ERROR:  operator does not exist: character varying || bytea
> HINT:  No operator matches the given name and argument type(s). You may
> need to add explicit type casts.
> CONTEXT:  SQL statement "SELECT   $1  || decode(to_hex( $2 ), 'hex')"

Hmm. Strange.

Does it happen in a plpgsql function, or when issuing the select as
PREPARE statement via pgadmin?

Which PostgreSQL version are you running?

Markus

--=20
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org



--=__PartAC888FE7.2__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"=
>
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt MS Sans Serif">
<DIV>I haven't got enough permissions to install new programs. Big =
brother... ;-)</DIV>
<DIV>I get the error in a plpgsql function</DIV>
<DIV>I use PostgreSQL 8.1.4 with EMS SQL Manager 2005 (3.6.0.1).<BR><BR>&gt=
;&gt;&gt; Markus Schaber &lt;schabi@logix-tt.com&gt; 2006-11-27 16:53 =
&gt;&gt;&gt;<BR></DIV>
<DIV style=3D"COLOR: #000000">Hi, Bart,<BR><BR>Bart Degryse wrote:<BR><BR>&=
gt; I should have said "The ICT department doesn't give me access to =
the<BR>&gt; psql command line interface".<BR><BR>Hmm, and you can't =
install psql on the same host you use to run pgadmin?<BR><BR>It's just a =
client, that connects to PostgreSQL the same way as pgamdin.<BR><BR><BR>&gt=
; ERROR:&nbsp; operator does not exist: character varying || bytea<BR>&gt; =
HINT:&nbsp; No operator matches the given name and argument type(s). You =
may<BR>&gt; need to add explicit type casts.<BR>&gt; CONTEXT:&nbsp; SQL =
statement "SELECT&nbsp;&nbsp; $1&nbsp; || decode(to_hex( $2 ), 'hex')"<BR><=
BR>Hmm. Strange.<BR><BR>Does it happen in a plpgsql function, or when =
issuing the select as<BR>PREPARE statement via pgadmin?<BR><BR>Which =
PostgreSQL version are you running?<BR><BR>Markus<BR><BR>-- <BR>Markus =
Schaber | Logical Tracking&amp;Tracing International AG<BR>Dipl. Inf.&nbsp;=
&nbsp;&nbsp;&nbsp; | Software Development GIS<BR><BR>Fight against =
software patents in Europe! <A href=3D"http://www.ffii.org">www.ffii.org</A=
><BR><A href=3D"http://www.nosoftwarepatents.org">www.nosoftwarepatents.org=
</A><BR></DIV></BODY></HTML>

--=__PartAC888FE7.2__=--