Postgres Pro
Downloads
Home   >   mailing lists

decode('hallo',???) - Mailing list pgsql-sql

From Fritz Lehmann-Grube
Subject decode('hallo',???)
Date
Msg-id 3D6BDFB6.8080905@math.tu-berlin.de
Whole thread Raw
Responses Re: decode('hallo',???)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Mathieu Arnold
Date:
Subject: triggers and plpgsql question
Next
From: Bruce Momjian
Date:
Subject: Re: decode('hallo',???)