From: Dorian Taylor <leg0@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: case statement in group by clause
Date: Mon, 15 Apr 2002 10:44:05
Message-ID: <F264UVvjMa7YflPcTHL00005ea1@hotmail.com> (raw)
Greetings,
I can't remember if I asked the list this before (it's been a very hectic
month), if so, please disregard. I'm trying to find the most elegant way of
integrating SQL into an application I am writing which has a potential for
N^3*M fairly similar queries (Luckily enough N is 3 and M is 6, but could
easily and very soon become more). Rather than explicitly write each of
these out, or concoct some sort of illegible mutant
string-concatenation/bind parameter frankenstein, I would like to simply
create one massive query riddled with case statements triggered by named
bind parameters. What is holding me back from this is the inability to
coerce certain column types in a case statement in a GROUP BY clause. Now,
the obvious solution would be to flatten each test out to return a value of
the same type, although I'm not too sure how to access the original sorting
function/operator that is associated with a GROUP BY clause. I'm sure this
isn't a new problem, but I've run into great difficulty finding anything on
the subject. Please advise.
Regards,
Dorian
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
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: leg0@hotmail.com
Subject: Re: case statement in group by clause
In-Reply-To: <F264UVvjMa7YflPcTHL00005ea1@hotmail.com>
* 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