[postgis-users] Nearest line from a point

[Jaime Casanova]

On Mon, Aug 22, 2011 at 2:27 AM, Jaime Casanova <jaime at 2ndquadrant.com> wrote:
>
> and answering your question the column is of type geometry so i don't
> know why the casts to geography (this also happens in the explain i'm
> posting here), maybe because of the SRID i choose? (which is 4326)
>

and the answer is: yes, it's because of the SRID

http://postgis.refractions.net/documentation/manual-1.5/ch04.html#PostGIS_Geography
"""
Standard geometry type data will autocast to geography if it is of SRID 4326.
"""

can this be the reason of the problem? what SRID should i have be using?

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