ulka salvi wrote:
u can try this
SELECT a,b,c,CAST(d AS float)
AS N 'd',e,f,g INTO dbo.newtable
Ulka
Did not follow.
Example,
create view v_test as select * from test1;
create table test(col1 varchar(12));
I'd like to:
alter table test alter column col1 type varchar(128);
Tried your suggested:
create or replace view v_test as select CAST( col1 as varchar(128)) from
test;
Got:
cannot change data type of view column "col1"
--
Lu Ying
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
