FUNCTION  fRegionContainsPointEq

Returns 1 if specified region contains specified ra,dec point, else returns zero.

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

parameters

  • regionid bigint -- Region object identifier
  • ra float NOT NULL, -- Right ascension, --/U degrees
  • dec float NOT NULL, -- Declination, --/U degrees
    Sample call to find if regionID 345 contains the North Pole

    select dbo.fRegionContainsPointEq(7,0,90)

    see also fRegionContainsPointXYZ
  • Input and output parameters

    nametypelengthinoutpnum
    @rafloat8input2
    @decfloat8input3
     bit1input0
    @regionIDbigint8input1