
--create a table with 4 columns, 2 columns for each point(longitude, latitude)
create table distances (alongitude double, alatitude double, blongitude double, blatitude double);

-- insert some values into the table.
insert into distances values
(cast(12.5 as double),cast(16.2 as double),cast(18.7 as double),cast(4.5 as double)),
(cast(1.5 as double),cast(15.1 as double),cast(1.5 as double),cast(8.7 as double)),
(cast(0 as double),cast(1 as double),cast(0 as double),cast(1 as double)),
(cast(0 as double),cast(10 as double),cast(0 as double),cast(12 as double));

-- Read the table
select * from distances;

-- Calculate the distance between the points.

select distances.alongitude,distances.alatitude,distances.blongitude,distances.blatitude,
       ST_Length(ST_LineString(distances.alongitude,distances.alatitude,distances.blongitude,distances.blatitude)) AS distance
from distances;