[postgis-users] Postgres/PostGIS and date field

[Vincenzo Patruno]

Hi list!

In my file .map I wrote something like


select the_geom .......... (end_date -  now() >= 10) as green and (end_date - now() < 0) as red .... from ....



The idea is using different coloured markers for expired points  or valid points

After upgrading Postgres/Gis with last available versions, the query above doesn't work anymore because  I cannot compare date types with integers .......
Any idea?

Thanks in advance

Vinc