X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3F5DB4758E6 for ; Tue, 8 Apr 2003 07:17:33 -0400 (EDT) Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (Postfix) with ESMTP id D6A88474E42 for ; Tue, 8 Apr 2003 07:17:31 -0400 (EDT) Received: from oasis.net.au (localhost [127.0.0.1]) by water.oasis.net.au (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id VAA02482 for ; Tue, 8 Apr 2003 21:20:44 +1000 X-Authentication-Warning: water.oasis.net.au: Host localhost [127.0.0.1] claimed to be oasis.net.au From: "Rudi Starcevic" To: pgsql-sql@postgresql.org Subject: Re: CASE Date: Tue, 8 Apr 2003 21:20:44 +1000 Message-Id: <20030408112044.M7251@oasis.net.au> In-Reply-To: <20030408110958.GX1712@pirmabanka.lv> References: <3E928853.7090801@oasis.net.au> <20030408094039.GS1712@pirmabanka.lv> <20030408105759.M33127@oasis.net.au> <20030408110958.GX1712@pirmabanka.lv> X-Mailer: Open WebMail X-OriginatingIP: 203.220.114.18 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Spam-Status: No, hits=-27.4 required=5.0 tests=BAYES_01,IN_REP_TO,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES,X_AUTH_WARNING autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/110 X-Sequence-Number: 12811 Victor, Thanks again, I'll try first thing in the morning as I'm at home now. Now I can sleep well knowing a solution is at hand :-) I'm very pleased as that was a small part of what I think is an advanced query and look forward to seeing it work. I'll send a reply first thing tomorrow when I get to work. Cheers Rudi. > * Rudi Starcevic [08.04.2003 14:06]: > > When casting inside a COALESCE function should it be something like: > > > > WHEN COALESCE( MAX(e.edate),'2003-01-01'::date ) >= now()::date THEN 'events' > > Yes. > Please, try it and report if it works. > > -- > > Victor Yegorov