X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 685AFD1B8C8 for ; Tue, 27 Apr 2004 03:54:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 40298-08 for ; Tue, 27 Apr 2004 03:54:02 -0300 (ADT) Received: from chn-dns.primus-india.net (chn-dns.primus-india.net [203.196.153.7]) by svr1.postgresql.org (Postfix) with ESMTP id D163BD1B575 for ; Tue, 27 Apr 2004 03:53:58 -0300 (ADT) Received: from ivesia67 (ptil-138-190-chn.primus-india.net [203.196.190.138] (may be forged)) by chn-dns.primus-india.net (8.12.8/8.12.8) with SMTP id i3R5nutj005533 for ; Tue, 27 Apr 2004 11:20:09 +0530 Message-ID: <00f501c42c24$7c16f2a0$7502a8c0@hdsc.com> From: "kumar" To: "pgsql" Subject: Customised Encoding Date: Tue, 27 Apr 2004 02:54:03 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00F2_01C42C02.E60B8D50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200404/292 X-Sequence-Number: 17667 This is a multi-part message in MIME format. ------=_NextPart_000_00F2_01C42C02.E60B8D50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Friends, Postgres 7.3.2 Runing on Linux 7.2 I would like to convert any values in between 1 to 2^16 into a single chara= ctor. And decode that single char to get back the numeric value again. Any = function to do that in Postgres SQL Server. Please shed some light. Thanks Kumar ------=_NextPart_000_00F2_01C42C02.E60B8D50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Friends,
 
Postgres 7.3.2 Runing on Linux 7.2<= /DIV>
 
I would like to convert any values in betw= een 1 to=20 2^16 into a single charactor. And decode that single char to get back=20 the numeric value again. Any function to do that in Postgres SQL=20 Server.
 
Please shed some light.
 
Thanks
Kumar
------=_NextPart_000_00F2_01C42C02.E60B8D50--