Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 30614 invoked from network); 1 Apr 2008 00:31:25 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Apr 2008 00:31:25 -0000 Received: (qmail 72804 invoked by uid 500); 1 Apr 2008 00:31:24 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 72775 invoked by uid 500); 1 Apr 2008 00:31:24 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 72758 invoked by uid 99); 1 Apr 2008 00:31:24 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 31 Mar 2008 17:31:24 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [63.82.107.6] (HELO red.amberpoint.com) (63.82.107.6) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Apr 2008 00:30:43 +0000 Received: from [127.0.0.1] (bp-laptop.edgility.com [10.10.12.203]) by red.amberpoint.com (8.14.0/8.12.11) with ESMTP id m310UrxZ007026 for ; Mon, 31 Mar 2008 17:30:53 -0700 (PDT) Message-ID: <47F1823D.5090602@amberpoint.com> Date: Mon, 31 Mar 2008 17:30:53 -0700 From: Bryan Pendleton User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: Derby Discussion Subject: Re: is it easy to change int to double? References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > Is there an easy way to change a column type from int to double while > automatically converting the data? One technique is as follows: 1) alter table add double-column 2) update table set double-column = int-column 3) alter table drop int-column thanks, bryan