The FIS and IRC source catalogs are stored in
Views are defined as
special subsets of the original table, however,
Tables and Views look the same for the user.
The name of Tables or Views can be set after `
in the SQL statement.
The list of columns and their descriptions of Tables and Views
are shown in Tables page and
We prepared a number of Functions
for you to use SQL calls efficiently.
Functions take some arguments,
execute a previously defined sequence of commands, and
returns value(s) or table.
Their names are prefixed by f, like in fGetNearbyObjCel or
The functions can be used after
SELECT' or `
FROM' keyword in the SQL statement.
The version of catalogs in Tables(Views) differ in databases. However, there is no differences about functions.
Here is an example of SQL call to get 10 object within 50arcmins of a point (ra='12:34:56.999', dec='-65:43:21.111').
fGetNearbyObjCel() function uses an optimized sequence for the radial search,
and returns a table which contains minimum set of columns including
objID of found objects.
You have to set two numerical values in degree to
the 3rd and 4th arguments of this function.
But you can also use string expression of `hh:mm:ss' and `dd:mm:ss' style
by using fLonStr2Deg() and fLatStr2Deg() functions, since
they convert a string expression into a numerical value in degree.
Using Functions is the most easy way to obtain the performance/convenience for SQL search. Before writing the SQL call, please read the Function list and search the functions suitable to your request.