Re: decode('hallo',???)

Fritz Lehmann-Grube wrote:
> 
> hallo somebody,
> 
> what do the functions "encode" and "decode" expect as arguments ?test=> \df decode                         List of
functionsResult data type |   Schema   |  Name  | Argument data types
------------------+------------+--------+---------------------bytea            | pg_catalog | decode | text, text(1
row)

> 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 ?

Decode is working.  The message is complaining about the encoding you
have for the session.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073