CASE Select, referring to selected value

Поиск
Список
Период
Сортировка
От Nick Riemondi
Тема CASE Select, referring to selected value
Дата
Msg-id fc.009863ef00088e10009863ef00088e10.88e1e@fc2.outerscape.net
обсуждение исходный текст
Ответы Re: CASE Select, referring to selected value  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-sql
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






В списке pgsql-sql по дате отправления:

Предыдущее
От: Roberto Mello
Дата:
Сообщение: Re: pl/pgsql capabilities?
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: Re: CASE Select, referring to selected value