Postgres Pro
Downloads
Home   >   mailing lists

decode function - Mailing list pgsql-bugs

From gerard manvu
Subject decode function
Date
Msg-id 1070896622022342@lycos-europe.com
Whole thread Raw
Responses Re: decode function  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Tree view 
Hi
I don't know if it is really a bug or a missuse of postgresql but when I is=
sue the following request
select decode(encode('=B5'::bytea, 'escape'), 'escape');
, the result is \346, not '=B5'.
Any help or a forum link ?

Thanks in advance
Gerard.
PS: PostGreSQL 7.4, Red Hat 8, Base under SQL_ASCII or UNICODE (doesn't wor=
k either)

Les noms de domaine les moins chers du march=E9 : 6,49 euros HT sur http://=
www.lycos.fr/pro .

pgsql-bugs by date:

Previous
From: saint
Date:
Subject: (ver. 7.4) select netmask('192.168.1.5/24') return '255.255.255.0/24' not '255.255.255.0' (example in docs)
Next
From: "Dhaval Bhagat"
Date:
Subject: java.lang.NullPointerException - at org.postgresql.Connection.ExecSQL(Connection.java:312)