I am trying to get the length of a line between two selected points. The points reside in table subs and are utilizing srid 4236.
I can verify the selection exists...
SELECT id, name, geom FROM subs where name = 'DALLAM COUNTY'or name = 'DALHART';
Which returns the expected results...
However when I try to construct line with the same selection I get empty results?
SELECT ST_Length(ST_Transform(ST_MakeLine(geom), 4236)) FROM subs where name = 'DALLAM COUNTY'or name = 'DALHART';
The sql returns empty results.
What am I missing?