https://simbad.idia.ac.za:443/simbad/sim-tap ADQL 2.0 ADQL 2.0

uppercase(str VARCHAR) -> VARCHAR

Put all characters of the given string in upper-case.

lowercase(str VARCHAR) -> VARCHAR

Put all characters of the given string in lower-case.

normId(id VARCHAR) -> VARCHAR

Normalise the given Simbad's object identifier (e.g. 'm1', 'andromeda').

array_agg(str VARCHAR) -> VARCHAR

Aggregate inside an array the value of the given expression for each row.

regexp(str VARCHAR, pattern VARCHAR) -> INTEGER

Determine whether the given string - str - matches the given regular expression - pattern. If yes, 1 is returned, else 0.

radec2sexa(ra DOUBLE, dec DOUBLE, prec SMALLINT) -> VARCHAR

Format the given coordinates into a Sexagesimal notation.

string_agg(str VARCHAR, delim VARCHAR) -> VARCHAR

Aggregate inside a single string the value of the given expression for each row. Row value are separated by the given string - delim.

smb_get_ids(oid BIGINT, maximum DOUBLE) -> VARCHAR

Aggregate inside a single string the identifiers of the given oid. Row value are separated by pipe string (limited to maximum given). application/fits moc application/fits fits text/plain text text/csv csv text/tab-separated-values tsv application/json json text/html html application/x-votable+xml;serialization=TABLEDATA votable/td application/x-votable+xml;serialization=FITS votable/fits application/x-votable+xml votable application/x-votable+xml;serialization=BINARY2 votable/b2 432000 8640000 1080 3600 50000 2000000 200000 200000 https://simbad.idia.ac.za:443/simbad/sim-tap/tables https://simbad.idia.ac.za:443/simbad/sim-tap/capabilities https://simbad.idia.ac.za:443/simbad/sim-tap/examples https://simbad.idia.ac.za:443/simbad/sim-tap/availability