aboutsummaryrefslogtreecommitdiffstats
path: root/script/handle-mail-replies
diff options
context:
space:
mode:
Diffstat (limited to 'script/handle-mail-replies')
0 files changed, 0 insertions, 0 deletions
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-26 14:40:19 +0000
an class="w"> + cos(radians($1)) * cos(radians(latitude)) * cos(radians($2 - longitude)))::numeric, 14) ) as distance from problem where longitude is not null and latitude is not null and radians(latitude) > radians($1) - ($3 / R_e()) and radians(latitude) < radians($1) + ($3 / R_e()) and ( abs(radians($1)) + ($3 / R_e()) > pi() / 2 -- case where search pt is near pole or ( radians(longitude) > radians($2) - asin(sin($3 / R_e())/cos(radians($1))) and radians(longitude) < radians($2) + asin(sin($3 / R_e())/cos(radians($1))) ) ) -- ugly -- unable to use attribute name "distance" here, sadly and R_e() * acos(trunc( (sin(radians($1)) * sin(radians(latitude)) + cos(radians($1)) * cos(radians(latitude)) * cos(radians($2 - longitude)))::numeric, 14) ) < $3 order by distance desc ' language sql stable; commit;