You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Amir Michail <am...@gmail.com> on 2008/04/01 01:47:46 UTC

is it easy to change int to double?

Hi,

Is there an easy way to change a column type from int to double while
automatically converting the data?

Amir

Re: is it easy to change int to double?

Posted by Bryan Pendleton <bp...@amberpoint.com>.

> 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