Re: virtual fields on VIEW?

hi,

raptor@tvskat.net wrote:
> create view as select
>         t1.id, t1.date, t1.field1, t1.field2,
>         t2.fieldA, t2.fieldB,
>         state, stuff
>   from table1 as t1, table2 as t2
>   where t1.id = t2.fkID
>
>
>>>WHERE "state" is caluclated like this :
>
>
> state = 'red' if date > today
> state = 'green' if date < today
> state = 'blue' unless date
>
>
>>>AND 'stuff' is concatenation of t1.field2 and  t2.fieldA.
> can this be done, if yes how.

try with case:

case when date > current_timestamp then 'red' when date <
current_timestamp then 'green' else 'blue' end as state,
t1.field2||t2.fieldA as stuff

C.