[postgis-users] Postgres/PostGIS and date field

Vincenzo Patruno patruno at istat.it
Tue Dec 2 03:04:16 PST 2008


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



More information about the postgis-users mailing list