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

Version	Path
tac_scribe-0.6.2	scratchpad
tac_scribe-0.6.0-java	scratchpad
tac_scribe-0.6.0	scratchpad
tac_scribe-0.5.0	scratchpad
tac_scribe-0.4.0	scratchpad
tac_scribe-0.3.0-java	scratchpad
tac_scribe-0.3.0	scratchpad
tac_scribe-0.2.1	scratchpad
tac_scribe-0.2.1-java	scratchpad
tac_scribe-0.2.0-java	scratchpad
tac_scribe-0.2.0	scratchpad
tac_scribe-0.1.1	scratchpad