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
|
Список | 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 по дате отправления: