FUNCTION fGetNearbyObjEq

Returns table of objects from @table within @r arcmins of an Equatorial point (@ra,@dec).

There is no limit on the number of objects returned, but there are about 40 per sq arcmin.

returned table:

objID bigint PRIMARY KEY, -- Photo object identifier

htmID bigint, -- Hierarchical Trangular Mesh id of this object

cx float NOT NULL, -- x,y,z of unit vector to this object

cy float NOT NULL,

cz float NOT NULL,

distance float -- distance in arc minutes to this object from the ra,dec.

Sample call to find all the Galaxies within 5 arcminutes of ra,dec 185,0
SELECT * FROM Galaxy AS G, dbo.fGetNearbyObjEq(185,0,5,1) AS N WHERE G.objID = N.objID
(see also fGetNearestObjEq, fGetNearbyObjXYZ, fGetNearestObjXYZ)

Name Type Length inout pnum

@ra float 8 input 1

@dec float 8 input 2

@r float 8 input 3

@table tinyint 1 input 4

objID bigint 8 output 1

cx float 8 output 2

cy float 8 output 3

cz float 8 output 4

htmID bigint 8 output 5

distance float 8 output 6

Name	Type	Length	inout	pnum
@ra	float	8	input	1
@dec	float	8	input	2
@r	float	8	input	3
@table	tinyint	1	input	4
objID	bigint	8	output	1
cx	float	8	output	2
cy	float	8	output	3
cz	float	8	output	4
htmID	bigint	8	output	5
distance	float	8	output	6