Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B76489F9A3D for ; Tue, 4 Sep 2007 08:03:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 37340-10 for ; Tue, 4 Sep 2007 08:03:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web31811.mail.mud.yahoo.com (web31811.mail.mud.yahoo.com [68.142.207.74]) by postgresql.org (Postfix) with SMTP id 0B16E9F9730 for ; Tue, 4 Sep 2007 08:03:32 -0300 (ADT) Received: (qmail 88441 invoked by uid 60001); 4 Sep 2007 11:03:31 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=FxW1Wu+Kr0zE0iK/H4VNyL9Q5kgzKh8bmrIw3z/reJ1lBRjyKmpi9g88nEQ8Kj8KT7+t2Ij+BIkNHjU0AIIORBpddic0UvShRIVbiVjCwuGuMfAxWbnoc31dHsIROb9rpnMB6L5MJbYQjt4Q8f+j6h3QjDgZsuxfRiwY8eFfT90=; X-YMail-OSG: .yiLgQ0VM1lrznBsPOJILgOTrDbnpmikU1tYsN16SauFMEpHdgjMQ4u3s4W1N66O.0_DuQkKo6bxaeM6DfESUNu0L8RCdkMKGYMK8hZmy3wYeq_9_SU7t4AvBg-- Received: from [75.84.89.248] by web31811.mail.mud.yahoo.com via HTTP; Tue, 04 Sep 2007 04:03:31 PDT Date: Tue, 4 Sep 2007 04:03:31 -0700 (PDT) From: Richard Broersma Jr Subject: Re: Cast on character columns in views To: "Luiz K. Matsumura" Cc: pgsql-sql@postgresql.org In-Reply-To: <46DCFD6D.20803@planit.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <819244.86005.qm@web31811.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.131 tagged_above=0 required=5 tests=AWL=0.871, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 200709/31 X-Sequence-Number: 29244 --- "Luiz K. Matsumura" 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.