Thanks Jorge but it isn't the matter. I'd know why postgis have a different way to calculate the distance with the same sql query.
2017-04-13 12:37 GMT+02:00 Jorge Gustavo Rocha <[email protected]>: > 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 > > [email protected] > > 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 > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
