I finally thought to try this about an hour after posting. Doh! Works
perfectly.
Thanks!
[EMAIL PROTECTED] writes:
>On Mon, 1 Jul 2002, Nick Riemondi wrote:
>
>Just rewrite your case statement in the where clause.
>
>> Hi!
>> I've got 2 date fields in table which constitute a term. On select I
> 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 ">"
>
> Doe
On Mon, 1 Jul 2002, Nick Riemondi wrote:
Just rewrite your case statement in the where clause.
> 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 ab
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 (curre
