Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 195AD63473F
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 26 May 2009 12:48:32 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 33621-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 26 May 2009 12:48:31 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from perseverance.services.encs.concordia.ca
	(perseverance-96.encs.concordia.ca [132.205.96.94])
	by mail.postgresql.org (Postfix) with ESMTP id 090F263473B
	for <pgsql-sql@postgresql.org>; Tue, 26 May 2009 12:48:30 -0300 (ADT)
Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca
	[132.205.47.225])
	by perseverance.services.encs.concordia.ca (envelope-from
	emilu@encs.concordia.ca) (8.13.7/8.13.7) with ESMTP id
	n4QFmQA6014633; Tue, 26 May 2009 11:48:26 -0400
Message-ID: <4A1C0F49.5030307@encs.concordia.ca>
Date: Tue, 26 May 2009 11:48:25 -0400
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Thunderbird 2.0.0.21 (X11/20090302)
MIME-Version: 1.0
To: ulka salvi <ulka3005@gmail.com>,
	PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Re: Allow column type to change without worrying about view
	dependencies
References: <4A16BCCD.1020508@encs.concordia.ca>
	<e81014000905260236q798cf3d0v886eeae8a3d4c117@mail.gmail.com>
In-Reply-To: <e81014000905260236q798cf3d0v886eeae8a3d4c117@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Scanned-By: MIMEDefang 2.58 on perseverance.encs.concordia.ca at 2009/05/26
	11:48:26 EDT
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200905/111
X-Sequence-Number: 32603

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