2 MAST STScI Registry TAP service STScI RegTAP ivo://archive.stsci.edu/regtap Space Telescope Science Institute Archive Space Telescope Institute MAST archive STScI Registry Team vo-registry@stsci.edu Virtual Observatory Catalogs ADQL The MAST Archive at STScI TAP end point for registry metadata. The Table Access Protocol (TAP) lets you execute queries against our database tables, inspect various metadata, and upload your own data. Tables exposed through this endpoint include are only for the Registry Relational database https://mast.stsci.edu/vo-tap/api/v0.1/registry 2 https://mast.stsci.edu/vo-tap/api/v0.1/registry Registry 1.1 ADQL 2.0 ADQL 2.0
ivo_string_agg(expression TEXT, delimiter TEXT) -> TEXT
An aggregate function returning all values of expression within a GROUP contcatenated with delimiter
ivo_hashlist_has(hashlist TEXT, item TEXT) -> INTEGER
The function takes two strings; the first is a list of words not containing the hash sign (#), concatenated by hash signs, the second is a word not containing the hash sign. It returns 1 if, compared case-insensitively, the second argument is in the list of words coded in the first argument. The behaviour in case the the second argument contains a hash sign is unspecified.
ivo_nocasematch(value TEXT, pattern TEXT) -> INTEGER
ivo_nocasematch returns 1 if pattern matches value, 0 otherwise. pattern is defined as for the SQL LIKE operator, but the match is performed case-insensitively. This function in effect provides a surrogate for the ILIKE SQL operator that is missing from ADQL.
ivo_hasword(haystack TEXT, needle TEXT) -> INTEGER
ivo_hasword returns 1 if needle shows up in haystack, 0 otherwise. This is for "google-like"-searches in text-like fields. In word, you can actually employ a fairly complex query language; see http://www.postgresql.org/docs/8.3/static/textsearch.html for details. application/x-votable+xml;serialization=tabledata votable/td text/csv;header=present csv application/json;header=present json 2 https://mast.stsci.edu/vo-tap/api/v0.1/registry 2 https://mast.stsci.edu/vo-tap/api/v0.1/registry/availability 2 https://mast.stsci.edu/vo-tap/api/v0.1/registry/capabilities 2 https://mast.stsci.edu/vo-tap/api/v0.1/registry/tables