[postgis-users] Calculate the distance between a point and a line

[Luca Bertoncello]

Am 06.01.2021 16:27, schrieb Paul Ramsey:

Hi Paul,

> (a) you have the longitude and latitude reversed in your POINT

Arghhhh!!!!! OK, with the parameter in the correct way of course it 
works...

> (b) use ST_DistanceSpheroid() or cast to geography instead of doing
> that heinous mercator hack

I don't have this function in my instance of PostGIS... Maybe I use an 
old version? I installed it from Debian Repo and I have a Debian 10...

Thanks
Luca Bertoncello
(lucabert at lucabert.de)