Hi, after some tries, i haven't managed to make this query use the GiST index that was created on columns transmitter_mv.punto nor rowlatlong.punto and it finishes using a seq scan on table transmitter_mv for every row in rowfreqlevel that satisfies the join and where conditions.
Stephen Woodbridge, made me notice in http://postgis.refractions.net/pipermail/postgis-users/2011-August/030575.html that in the plan the POINT is being casted to geography so i decided to bite the bullet and use geography columns intead but when i tried to create the points from long/lat pairs i got this error (which i didn't get when the column was geometry) """ db=# update transmitter_mv set punto = st_makepoint(tx_long, tx_lat); ERROR: Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type """ any ideas why this is happening? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
