X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 455FDD1C510 for ; Wed, 23 Jul 2003 16:47:45 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 42041-03 for ; Wed, 23 Jul 2003 13:47:02 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 56214D1C50A for ; Wed, 23 Jul 2003 13:47:43 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h6NGlhQ3013917; Wed, 23 Jul 2003 12:47:43 -0400 (EDT) To: mallah@trade-india.com Cc: pgsql-performance@postgresql.org Subject: Re: factoring problem with view in 7.3.3 [ PARTIALLY SOLVED ] In-reply-to: <1270.219.65.226.100.1058978229.squirrel@mail.trade-india.com> References: <200307231551.48444.mallah@trade-india.com> <13446.1058975001@sss.pgh.pa.us> <1270.219.65.226.100.1058978229.squirrel@mail.trade-india.com> Comments: In-reply-to message dated "Wed, 23 Jul 2003 22:07:09 +0530" Date: Wed, 23 Jul 2003 12:47:43 -0400 Message-ID: <13916.1058978863@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/396 X-Sequence-Number: 2689 writes: > the column 'generated' was timestamp in 2 place and date in 2 place, > i wanted it in my and did a typecasting in the view below > but it suffers from the same problem . AFAIR it should work if you insert casts into the UNION's member selects. Maybe you didn't get the casting quite right? (For instance, "timestamp" isn't "timestamp with time zone" ...) regards, tom lane