Hai Alberto,
Please feel free to add a feature request at https://github.com/monetdb/monetdb/issues That helps us keeping track of user wishes and plan our roadmap accordingly.
Thanks Jennie
On 21 Apr 2022, at 15:56, Alberto Ferrari aferrari@starconnecting.com wrote:
I just found: "Change of the data type of a column is not supported. Instead use command sequence: ALTER TABLE tbl ADD COLUMN new_column _new_data_type_; UPDATE tbl SET new_column = CONVERT(old_column, _new_data_type_); ALTER TABLE tbl DROP COLUMN old_column RESTRICT; ALTER TABLE tbl RENAME COLUMN new_column TO old_column"
Maybe you could add and sql command that internally performs all those steps in just one step?
regards
El jue, 21 abr 2022 a la(s) 10:38, Alberto Ferrari (aferrari@starconnecting.com) escribió:
Hi all, I need to change the data type of a column. (I know the trick of creating a new temp column, copy the data from old, etc...) But I expected newer versions already have a command equivalent to MySql "CHANGE COLUMN" or similar, but I can't found in monetdb documentation. All examples of "ALTER COLUMN" are for setting other attributes. Anybody knows a specific command to do what I need?
Kind regards, Alberto
users-list mailing list -- users-list@monetdb.org To unsubscribe send an email to users-list-leave@monetdb.org