> I create a temp table from the original. I then drop the original table.
> After that I create a new table, with the exact same names/attributes
> except the one field that I change to text. Then I do an insert, from the
> temp table to the new table. This errors out, stating that it cannot not
> put int data into a text field.
My SQL is a bit rusty, so the exact syntax might be of. You'll have to
explicitly cast the int4 column to 'text':
select f1, f2, int_column::text, f4, ... into table new_table from
old_table;
Maarten
--
Maarten Boekhold, [EMAIL PROTECTED]
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com
