Sha256: bc55d50dd2084cc9561f075ae894286766dfd0a5cd7f1d81624993621b520c97
Contents?: true
Size: 498 Bytes
Versions: 32
Compression:
Stored size: 498 Bytes
Contents
# Request Bogey Dope SELECT b.id, ST_AsText(b.position) AS human_position, b.position AS binary_position, b.altitude, b.heading, b.group, b.type, ST_DISTANCE(sub.position, b.position) as distance, degrees(ST_AZIMUTH(sub.position, b.position)) as bearing FROM public.units AS b CROSS JOIN LATERAL ( SELECT s.position, s.coalition FROM public.units AS s WHERE ID = '102' ) as sub WHERE NOT b.coalition = sub.coalition AND b.type LIKE 'Air+%' ORDER BY sub.position <-> b.position ASC LIMIT 10
Version data entries
32 entries across 32 versions & 1 rubygems