Re: Cast on character columns in views - Mailing list pgsql-sql

--- "Luiz K. Matsumura" <luiz@planit.com.br> wrote:
> When I drop the view first , and then create again the view (in a 
> separated transaction), now the command works! (this is a bug?)

Well according to the manual, it is working as it is intended to work:
http://www.postgresql.org/docs/8.2/interactive/sql-createview.html

I've created large SQL scripts that employ:

DROP VIEW IF EXITS viewname;

CREATE VIEW ...

Regards,
Richard Broersma Jr.