[postgis-users] Longitude and latitude ranges

[Jaime Casanova]

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