ORDER BY ST_MakePoint(coordenate,coordenate)::geography ST_MakePoint(0.0,0. ST_MakePoint(coordenate,coordenate)::geography)/1000

In order to use ST_Distance you have to cast the points to either geometry or geography.ĭemo: dbfiddle CREATE TABLE location (gid int, coordenate point) The data type point is not a PostGIS data type, but a geometric data type from PostgreSQL. The operator means distance, so using it on the ORDER BY clause you can order the result set by distance. ORDER BY coordenate::geography ST_MakePoint(0.0,0.0)::geography Make sure youre running your Chromecast on a 2.4GHz network frequency. Move your router closer to your Chromecast. Save to Google Keep in a single click Google Keep Chrome Extension. PayPal Honey: Automatic Coupons & Cash Back. Save money and earn rewards when you shop online. ST_Distance(ST_MakePoint(0.0,0.0)::geography, coordenate::geography)/1000ĭemo: dbfiddle CREATE TABLE location (gid int, coordenate geometry(point,4326)) View translations easily as you browse the web. To try out this new built-in Cast functionality, just make sure youre running the latest version of Chrome. To get distances in metres/kilometres you need to either transform your coordinates to a SRS that has metre as unit or, if possible, use geography instead of geometry, as ST_Distance returns the distance of two geography parameters in metres (1km = 1000m), e.g.

I get the google chrome logo when trying to cast