Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ERROR: input is out of range
- CONTEXT: SQL function "gc_dist1" statement 1
- create or replace function gc_dist1(_lat1 float8, _lon1 float8, _lat2 float8, _lon2 float8)
- returns float8 as $$
- select ACOS(SIN(radians($1))*SIN(radians($3))+COS(radians($1))*COS(radians($3))*COS(radians($4)-radians($2)))*6371;
- $$ language sql immutable;
- select gc_dist1(24.6269989013672,59.3357849157094,24.6269989013672,59.3357849121094);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement