[postgis-users] st_distance meter/degree

[Jorge Gustavo Rocha]

Hi Franco,

You can use the usual control statements IF THEN ELSE [1] to make it
exactly like you want.

[1]
https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html

Regards,

Jorge

Às 10:57 de 13-04-2017, franco base escreveu:
> Hi all.
> Is it possible that st_distance between point return meter distance if
> point are very close and degrees otherwise?
> 
> SELECT ST_distance ( ST_SetSRID
> (ST_MakePoint(45.4553804010375,9.11292550791171) ,4326), ST_SetSRID
> (ST_MakePoint(45.4553855607023,9.11291318106981) ,4326))
> 
> return 1.3 ( meter distance)
> 
> 
> SELECT ST_distance ( ST_SetSRID
> (ST_MakePoint(45.4553804010375,9.11292550791171) ,4326), ST_SetSRID
> (ST_MakePoint(45.4560699405679,9.1164832309759) ,4326))
> 
> return 0.003 (degrees distance)
> 
> 
> Thanks
> fb
> 
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> 

J. Gustavo
-- 
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor