Re: [SQL] Encoding and result string length

2004-04-08 Thread Richard Huxton
On Thursday 08 April 2004 10:32, kumar wrote: > > create table encodeco(c1 int4, c2 int4); > insert into encodeco values(1, 2); > select * from encodeco; > > So I want to encode the data while selecting. > select encode(c1,'base64') from encodeco; > So i tried > select encode('c1','ba

[SQL] Encoding and result string length

2004-04-08 Thread kumar
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(1, 2);select * from encodeco;   So I want to encode the data while selecting. select encode(c1,'base64')