Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2CBB64759A1
	for <pgsql-sql@postgresql.org>; Tue, 27 Aug 2002 16:23:19 -0400 (EDT)
Received: from mail.math.TU-Berlin.DE (mail.math.TU-Berlin.DE
 [130.149.12.212])
	by postgresql.org (Postfix) with ESMTP id EDBC6475843
	for <pgsql-sql@postgresql.org>; Tue, 27 Aug 2002 16:23:17 -0400 (EDT)
Received: from math.tu-berlin.de (methusalix.math.TU-Berlin.DE
	[130.149.13.129])
	by mail.math.TU-Berlin.DE (8.12.0.Beta10/8.12.0.Beta10) with ESMTP id
	g7RKNItM008536
	for <pgsql-sql@postgresql.org>; Tue, 27 Aug 2002 22:23:18 +0200 (MEST)
Message-ID: <3D6BDFB6.8080905@math.tu-berlin.de>
Date: Tue, 27 Aug 2002 22:23:18 +0200
From: Fritz Lehmann-Grube <lehmannf@math.TU-Berlin.DE>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: decode('hallo',???)
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/362
X-Sequence-Number: 9208


hallo somebody,

what do the functions "encode" and "decode" expect as arguments ?
I was puzzled when I got the following:

pgdocsample=# \encoding
SQL_ASCII
pgdocsample=# select decode('hallo','SQL_ASCII');
ERROR:  No such encoding as 'SQL_ASCII'

What have I understood wrong ?

Fritz