Re: Cast on character columns in views

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: "Luiz K(dot) Matsumura" <luiz(at)planit(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Cast on character columns in views
Date: 2007-09-04 11:03:31
Message-ID: 819244.86005.qm@web31811.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

--- "Luiz K. Matsumura" <luiz(at)planit(dot)com(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2007-09-04 11:08:47 Re: Cast on character columns in views
Previous Message Richard Huxton 2007-09-04 10:45:18 Re: Use of delete...returning in function problem