From: Nick Riemondi <nick@outerscape.net>
To: pgsql-sql@postgresql.org
Subject: CASE Select, referring to selected value
Date: Mon, 01 Jul 2002 17:00:18 -0500
Message-ID: <fc.009863ef00088e10009863ef00088e10.88e1e@fc2.outerscape.net> (raw)
Hi!
I've got 2 date fields in table which constitute a term. On select I'm
calculating that term, BUT I can't figure out how to refer to it in the
sql - or if it's possible. I'd like to be able to use the case returned
value for order, comparing, etc. Here's an example:
select case when (current_date > available) then ((end_date -
current_date) / 30)
when (current_date < available) then ((end_date - available) /
30)
end
from listing
This yields something along the line of:
case
------
2
39
11
64
...
which is great. Now, I'd like to be able to do this for example:
select case when (current_date > available) then ((end_date -
current_date) / 30)
when (current_date < available) then ((end_date - available) /
30)
end
from listing
where case > 4
which yields:
ERROR: parser: parse error at or near ">"
Does anyone know how I could accomplish this?
Thanks in Advance!
Nick
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: nick@outerscape.net
Subject: Re: CASE Select, referring to selected value
In-Reply-To: <fc.009863ef00088e10009863ef00088e10.88e1e@fc2.outerscape.net>
* 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