X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6C9CC11F6D15 for ; Mon, 10 Apr 2006 06:37:21 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.002 X-Spam-Level: X-Spam-Status: No, score=0.002 required=5 tests=[HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id flOnLMO-3k6w for ; Mon, 10 Apr 2006 06:37:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 3ED0411F68CA for ; Mon, 10 Apr 2006 06:37:13 -0300 (ADT) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k3A9UbbU029629 for ; Mon, 10 Apr 2006 15:00:37 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 07B62332669for ; Mon, 10 Apr 2006 15:00:37 +0530 (IST) Message-ID: <00e301c65c83$3f49a520$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Subject: alter column type Date: Mon, 10 Apr 2006 15:13:38 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00E0_01C65CB1.58648FB0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:81.29500 C:21 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Archive-Number: 200604/86 X-Sequence-Number: 21255 This is a multi-part message in MIME format. ------=_NextPart_000_00E0_01C65CB1.58648FB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi.. If i want to change the datatype of a column in a table.....What are = all the thigs i need to take care off. After somany records insertion if i change the datatype of the = column..What will be the effect of it. Please tell me /give suggestion what needs to be cosider at the time of = changing column type of a table. Incase of int to char/varchar/text/ etc. What are the different datatypes we should think about? Thank you, Sandhya ------=_NextPart_000_00E0_01C65CB1.58648FB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi..
  If i want to change the datatype of a column = in a=20 table.....What are all the thigs i need to take care off.
After somany records insertion if i change the = datatype of the=20 column..What will be the effect of it.
Please tell me /give suggestion what needs to be = cosider at=20 the time of changing column type of a table.
 
Incase of  int to char/varchar/text/ = etc.
What are the different datatypes we should think=20 about?
 
Thank you,
Sandhya
 
 
 
 
 
------=_NextPart_000_00E0_01C65CB1.58648FB0--