Encoding and result string length

From: "kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: Encoding and result string length
Date: 2004-04-08 09:32:07
Message-ID: 025001c41d4c$5db0bbc0$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear Friends,

Postgres 7.3.2 on Linux 8

I would like to fetch the datas from a table in a encoded format.

create table encodeco(c1 int4, c2 int4);
insert into encodeco values(10000, 20000);
select * from encodeco;

So I want to encode the data while selecting.
select encode(c1,'base64') from encodeco;

ERROR: Function encode(integer, "unknown") does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts

So i tried
select encode('c1','base64') from encodeco;

I got a result as
1 YzE=

But this is the encoded value for 'c1' and not for the value 10000.

Please shed some light.

Also is it possible to get the encoded values with only 2 charactors, irrespective of the values of c1 ranging from 100 to 10 million

Thanks
Kumar

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2004-04-08 11:00:16 Re: Encoding and result string length
Previous Message yek ching 2004-04-08 07:52:00 pgsql multi-database queries