X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2F8A94758E6
	for <pgsql-sql@postgresql.org>; Tue,  8 Apr 2003 06:54:49 -0400 (EDT)
Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2])
	by postgresql.org (Postfix) with ESMTP id D3146474E42
	for <pgsql-sql@postgresql.org>; Tue,  8 Apr 2003 06:54:47 -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
	UAA01940
	for <pgsql-sql@postgresql.org>; Tue, 8 Apr 2003 20:57:59 +1000
X-Authentication-Warning: water.oasis.net.au: Host localhost [127.0.0.1]
	claimed to be oasis.net.au
From: "Rudi Starcevic" <rudi@oasis.net.au>
To: pgsql-sql@postgresql.org
Subject: Re: CASE
Date: Tue, 8 Apr 2003 20:57:59 +1000
Message-Id: <20030408105759.M33127@oasis.net.au>
In-Reply-To: <20030408094039.GS1712@pirmabanka.lv>
References: <3E928853.7090801@oasis.net.au>
	<20030408094039.GS1712@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=-17.1 required=5.0
	tests=BAYES_01,IN_REP_TO,REFERENCES,UPPERCASE_25_50,
	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/108
X-Sequence-Number: 12809

Victor,

Thanks for your time ..

When casting inside a COALESCE function should it be something like:

WHEN COALESCE( MAX(e.edate),'2003-01-01'::date ) >= now()::date THEN 'events'

instead of:

WHEN COALESCE( MAX(e.edate),'2003-01-01') >= now()::date THEN 'events'

Regards
Rudi