| 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: | Whole Thread | Raw Message | 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
| 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 |