force view column varchar(32) to varchar(128) - Mailing list pgsql-sql

From Emi Lu
Subject force view column varchar(32) to varchar(128)
Date
Msg-id 4CE69181.1050803@encs.concordia.ca
Whole thread Raw
In response to Re: Overlapping Ranges- Query Alternative  ("Marc Mamin" <M.Mamin@intershop.de>)
Responses Re: force view column varchar(32) to varchar(128)  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: force view column varchar(32) to varchar(128)  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-sql
Hello,

Is there a way to force the view column change from varhcar(32) to 
varchar(128)?

Example:
===================
v1 (id varchar(32) ... )

There are more than 1000 other views depend on v1.

Instead of recreating all other 1000 views, is there a way postgresql 
8.3 can do/accept:

create or replace v1 AS

select id::varchar(128), ......

Thanks a lot!
--
Lu Ying



pgsql-sql by date:

Previous
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: obtaining difference between minimum value and next in size
Next
From: Andreas Kretschmer
Date:
Subject: Re: force view column varchar(32) to varchar(128)