X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C56425E4249 for ; Sun, 22 Aug 2004 06:47:32 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96045-09 for ; Sun, 22 Aug 2004 09:47:27 +0000 (GMT) Received: from hotmail.com (bay12-dav10.bay12.hotmail.com [64.4.35.184]) by svr1.postgresql.org (Postfix) with ESMTP id C323A5E40BA for ; Sun, 22 Aug 2004 06:47:25 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 22 Aug 2004 02:47:28 -0700 Received: from 210.184.255.200 by bay12-dav10.bay12.hotmail.com with DAV; Sun, 22 Aug 2004 09:47:28 +0000 X-Originating-IP: [210.184.255.200] X-Originating-Email: [siu_keith@hotmail.com] X-Sender: siu_keith@hotmail.com From: "Keith" To: Subject: add serial no Date: Sun, 22 Aug 2004 17:47:17 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0038_01C48870.11019E90" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Message-ID: X-OriginalArrivalTime: 22 Aug 2004 09:47:28.0385 (UTC) FILETIME=[09483710:01C4882D] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200408/236 X-Sequence-Number: 14631 This is a multi-part message in MIME format. ------=_NextPart_000_0038_01C48870.11019E90 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable Dear All, Someone can help me to solve the below problems 1. I create a table for a period of time, there is huge records already pos= ted.=20 I would like to alter table and add serial primary key on that table. It's= impossible to add serial no by hand. Please adv how can I add the serial = number automatically. 2. Is there any library to translate digit number to English, I mean transl= ate '1234' to 'one thousand two hundred thirty four'.. Pls help. regards ------=_NextPart_000_0038_01C48870.11019E90 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable
Dear All,
 
Someone can help me to solve the below=20 problems
 
1. I create a table for a period= of time,=20 there is huge records already posted.
I would like to alter table and add serial= primary=20 key on that table.  It's impossible to add serial no by hand. Ple= ase=20 adv  how can I add the serial number automatically.
 
2. Is there any library to translate digit= number=20 to English, I mean translate '1234' to 'one thousand two hundred thirty fou= r'..=20 Pls help.
 
regards
------=_NextPart_000_0038_01C48870.11019E90--