Re: UNICODE and PL/PGSQL - Mailing list pgsql-sql

From Markus Schaber
Subject Re: UNICODE and PL/PGSQL
Date
Msg-id 456B09DD.909@logix-tt.com
Whole thread Raw
In response to Re: UNICODE and PL/PGSQL  ("Bart Degryse" <Bart.Degryse@indicator.be>)
Responses Re: UNICODE and PL/PGSQL
List pgsql-sql
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

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

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


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: UNICODE and PL/PGSQL
Next
From:
Date:
Subject: Auto-Response: Re: UNICODE and PL/PGSQL