By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 7
| gid | geom | reference_point | distance_to_ref_point |
|---|---|---|---|
| 7 | POINT(-4.3098 54.2973) | POINT(-4.3098 54.2428) | 0.05449999999999733 |
| 6 | POINT(-4.3675 54.2428) | POINT(-4.3098 54.2428) | 0.05769999999999964 |
| 1 | POINT(-4.4156 54.2509) | POINT(-4.3098 54.2428) | 0.10610961313660537 |
| 2 | POINT(-4.4568 54.279) | POINT(-4.3098 54.2428) | 0.15139167744628546 |
| 3 | POINT(-4.4952 54.2742) | POINT(-4.3098 54.2428) | 0.18804020846616745 |
| 4 | POINT(-4.5405 54.2974) | POINT(-4.3098 54.2428) | 0.2370730899954694 |
| 5 | POINT(-4.5488 54.3591) | POINT(-4.3098 54.2428) | 0.2657944506568918 |
SELECT 7