Thank you for your help. Best regards,Baraa

Date: Tue, 5 Nov 2013 08:43:56 +0100 From: Stefan.Manegold@cwi.nl To: users-list@monetdb.org Subject: Re: Modify column datataype

Hi,

given that MonetDB is a column store, an explicit column copy should be sufficient (provided a different column name is acceptable; AFAIK, there is no support to rename a column):

alter table <tab> add column <new_col> <typ>; update <tab> set <new_col> = cast(<old_col> as <typ>); (alter table <tab> drop column <old_col>;)

Stefan

----- Original Message -----

...

Hello

There is no support (yet) for changing the underlying type of an individual column. It requires an explicit table copy.

regards, Martin

On 11/5/13 1:06 AM, baraa Mohamad wrote:

Hello,

I would like to know if it is possible to change a column type. I have a table with millions of records and I wand to change the type of the column (id) but I couldn't find how to do that.

Thanks in advance for your help,

Regards, Baraa

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list