[postgis-users] Longitude and latitude ranges

[Jaime Casanova]

On Fri, Aug 26, 2011 at 1:29 AM, Ture Pålsson <ture.palsson at gmail.com> wrote:
> 2011/8/23 Jaime Casanova <jaime at 2ndquadrant.com>:
>
>> 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?
>
> Perhaps this is a too-obvious question, but have you made sure that
> you don't have some "bad" point, with latitude and/or longitude out of
> range, that has somehow sneaked into your data set?
>

if i create geometry points it works like a charm, so i don't think so

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación