From: Rudi Starcevic <rudi@oasis.net.au>
To: pgsql-sql@postgresql.org
Subject: Re: CASE
Date: Tue, 8 Apr 2003 21:20:44 +1000
Message-ID: <20030408112044.M7251@oasis.net.au> (raw)
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>
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 <rudi@oasis.net.au> [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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rudi@oasis.net.au
Subject: Re: CASE
In-Reply-To: <20030408112044.M7251@oasis.net.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox