[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