ivoa job_upload jwst jwst public esdc_array_dims VARCHAR esdc_array_dims(n VARCHAR) -> VARCHAR n VARCHAR null null null esdc_array_element VARCHAR esdc_array_element(n VARCHAR, position INTEGER) -> VARCHAR n VARCHAR null null null position INTEGER null null null esdc_array_length INTEGER esdc_array_length(n VARCHAR, dim INTEGER) -> INTEGER n VARCHAR null null null dim INTEGER null null null esdc_array_ndims INTEGER esdc_array_ndims(n VARCHAR) -> INTEGER n VARCHAR null null null esdc_astrometric_parameter_error DOUBLE[21] esdc_astrometric_parameter_error(e_ra_deg DOUBLE, e_de_deg DOUBLE, e_plx DOUBLE, e_pm_ra DOUBLE, e_pm_de DOUBLE, de_ra DOUBLE, plx_ra DOUBLE, pm_ra_ra DOUBLE, pm_de_ra DOUBLE, plx_de DOUBLE, pm_ra_de DOUBLE, pm_de_de DOUBLE, pm_ra_plx DOUBLE, pm_de_plx DOUBLE, pm_de_pm_ra DOUBLE, parallax DOUBLE, radial_velocity DOUBLE, e_rv DOUBLE) -> DOUBLE[21] e_ra_deg DOUBLE null null null e_de_deg DOUBLE null null null e_plx DOUBLE null null null e_pm_ra DOUBLE null null null e_pm_de DOUBLE null null null de_ra DOUBLE null null null plx_ra DOUBLE null null null pm_ra_ra DOUBLE null null null pm_de_ra DOUBLE null null null plx_de DOUBLE null null null pm_ra_de DOUBLE null null null pm_de_de DOUBLE null null null pm_ra_plx DOUBLE null null null pm_de_plx DOUBLE null null null pm_de_pm_ra DOUBLE null null null parallax DOUBLE null null null radial_velocity DOUBLE null null null e_rv DOUBLE null null null esdc_astrometric_parameters DOUBLE[6] esdc_astrometric_parameters(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE) -> DOUBLE[6] ra DOUBLE null null null de DOUBLE null null null parallax DOUBLE null null null pm_ra DOUBLE null null null pm_de DOUBLE null null null radial_velocity DOUBLE null null null esdc_cardinality INTEGER esdc_cardinality(n VARCHAR) -> INTEGER n VARCHAR null null null esdc_case_condition VARCHAR esdc_case_condition(default_value VARCHAR, conditions VARCHAR, results VARCHAR) -> VARCHAR default_value VARCHAR null null null conditions VARCHAR null null null results VARCHAR null null null esdc_case_expression VARCHAR esdc_case_expression(input_value VARCHAR, default_value VARCHAR, condition_values VARCHAR, results VARCHAR) -> VARCHAR input_value VARCHAR null null null default_value VARCHAR null null null condition_values VARCHAR null null null results VARCHAR null null null esdc_coalesce VARCHAR esdc_coalesce(n VARCHAR) -> VARCHAR n VARCHAR null null null esdc_crossmatch_positional BIGINT esdc_crossmatch_positional(table_schema_a VARCHAR, table_name_a VARCHAR, table_schema_b VARCHAR, table_name_b VARCHAR, radius DOUBLE, output_table_name VARCHAR) -> BIGINT table_schema_a VARCHAR null null null table_name_a VARCHAR null null null table_schema_b VARCHAR null null null table_name_b VARCHAR null null null radius DOUBLE null null null output_table_name VARCHAR null null null esdc_current_date TIMESTAMP esdc_current_date() -> TIMESTAMP esdc_epoch_prop DOUBLE[6] esdc_epoch_prop(astrometric_parameters DOUBLE[6], ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[6] astrometric_parameters DOUBLE[6] null null null ref_epoch DOUBLE null null null out_epoch DOUBLE null null null esdc_epoch_prop DOUBLE[6] esdc_epoch_prop(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[6] ra DOUBLE null null null de DOUBLE null null null parallax DOUBLE null null null pm_ra DOUBLE null null null pm_de DOUBLE null null null radial_velocity DOUBLE null null null ref_epoch DOUBLE null null null out_epoch DOUBLE null null null esdc_epoch_prop_covariance DOUBLE[6][6] esdc_epoch_prop_covariance(ra DOUBLE, dec DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, e_ra_deg DOUBLE, e_de_deg DOUBLE, e_plx DOUBLE, e_pm_ra DOUBLE, e_pm_de DOUBLE, e_rv DOUBLE, de_ra DOUBLE, plx_ra DOUBLE, plx_de DOUBLE, pm_ra_ra DOUBLE, pm_ra_de DOUBLE, pm_ra_plx DOUBLE, pm_de_ra DOUBLE, pm_de_de DOUBLE, pm_de_plx DOUBLE, pm_de_pm_ra DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[6][6] ra DOUBLE null null null dec DOUBLE null null null parallax DOUBLE null null null pm_ra DOUBLE null null null pm_de DOUBLE null null null radial_velocity DOUBLE null null null e_ra_deg DOUBLE null null null e_de_deg DOUBLE null null null e_plx DOUBLE null null null e_pm_ra DOUBLE null null null e_pm_de DOUBLE null null null e_rv DOUBLE null null null de_ra DOUBLE null null null plx_ra DOUBLE null null null plx_de DOUBLE null null null pm_ra_ra DOUBLE null null null pm_ra_de DOUBLE null null null pm_ra_plx DOUBLE null null null pm_de_ra DOUBLE null null null pm_de_de DOUBLE null null null pm_de_plx DOUBLE null null null pm_de_pm_ra DOUBLE null null null ref_epoch DOUBLE null null null out_epoch DOUBLE null null null esdc_epoch_prop_error DOUBLE[21] esdc_epoch_prop_error(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, e_ra_deg DOUBLE, e_de_deg DOUBLE, e_plx DOUBLE, e_pm_ra DOUBLE, e_pm_de DOUBLE, e_rv DOUBLE, de_ra DOUBLE, plx_ra DOUBLE, pm_ra_ra DOUBLE, pm_de_ra DOUBLE, plx_de DOUBLE, pm_ra_de DOUBLE, pm_de_de DOUBLE, pm_ra_plx DOUBLE, pm_de_plx DOUBLE, pm_de_pm_ra DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[21] ra DOUBLE null null null de DOUBLE null null null parallax DOUBLE null null null pm_ra DOUBLE null null null pm_de DOUBLE null null null radial_velocity DOUBLE null null null e_ra_deg DOUBLE null null null e_de_deg DOUBLE null null null e_plx DOUBLE null null null e_pm_ra DOUBLE null null null e_pm_de DOUBLE null null null e_rv DOUBLE null null null de_ra DOUBLE null null null plx_ra DOUBLE null null null pm_ra_ra DOUBLE null null null pm_de_ra DOUBLE null null null plx_de DOUBLE null null null pm_ra_de DOUBLE null null null pm_de_de DOUBLE null null null pm_ra_plx DOUBLE null null null pm_de_plx DOUBLE null null null pm_de_pm_ra DOUBLE null null null ref_epoch DOUBLE null null null out_epoch DOUBLE null null null esdc_epoch_prop_error DOUBLE[21] esdc_epoch_prop_error(astrometric_parameters DOUBLE[6], astrometric_parameter_error DOUBLE[21], ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[21] astrometric_parameters DOUBLE[6] null null null astrometric_parameter_error DOUBLE[21] null null null ref_epoch DOUBLE null null null out_epoch DOUBLE null null null esdc_epoch_prop_pos VARCHAR esdc_epoch_prop_pos(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> VARCHAR ra DOUBLE null null null de DOUBLE null null null parallax DOUBLE null null null pm_ra DOUBLE null null null pm_de DOUBLE null null null radial_velocity DOUBLE null null null ref_epoch DOUBLE null null null out_epoch DOUBLE null null null esdc_greatest DOUBLE esdc_greatest(v1 DOUBLE, v2 DOUBLE) -> DOUBLE v1 DOUBLE null null null v2 DOUBLE null null null esdc_if_then_else VARCHAR esdc_if_then_else(condition VARCHAR, ouput_value VARCHAR, default_value VARCHAR) -> VARCHAR condition VARCHAR null null null ouput_value VARCHAR null null null default_value VARCHAR null null null esdc_least DOUBLE esdc_least(v1 DOUBLE, v2 DOUBLE) -> DOUBLE v1 DOUBLE null null null v2 DOUBLE null null null esdc_left VARCHAR esdc_left(string VARCHAR, n INTEGER) -> VARCHAR string VARCHAR null null null n INTEGER null null null esdc_length INTEGER esdc_length(string VARCHAR) -> INTEGER string VARCHAR null null null esdc_nullif VARCHAR esdc_nullif(value1 VARCHAR, value2 VARCHAR) -> VARCHAR value1 VARCHAR null null null value2 VARCHAR null null null esdc_position INTEGER esdc_position(substring VARCHAR, string VARCHAR) -> INTEGER substring VARCHAR null null null string VARCHAR null null null esdc_radial_velocity DOUBLE esdc_radial_velocity(pm_rv DOUBLE, parallax DOUBLE) -> DOUBLE pm_rv DOUBLE null null null parallax DOUBLE null null null esdc_right VARCHAR esdc_right(string VARCHAR, n INTEGER) -> VARCHAR string VARCHAR null null null n INTEGER null null null esdc_stddev DOUBLE esdc_stddev(n DOUBLE) -> DOUBLE n DOUBLE null null null esdc_substring VARCHAR esdc_substring(string VARCHAR, start_position INTEGER, length INTEGER) -> VARCHAR string VARCHAR null null null start_position INTEGER null null 0 length INTEGER null null 1 esdc_to_bigint BIGINT esdc_to_bigint(n DOUBLE) -> BIGINT n DOUBLE null null null esdc_to_boolean BOOLEAN esdc_to_boolean(n INTEGER) -> BOOLEAN n INTEGER null null null esdc_to_char VARCHAR esdc_to_char(n DOUBLE) -> VARCHAR n DOUBLE null null null esdc_to_double DOUBLE esdc_to_double(n DOUBLE) -> DOUBLE n DOUBLE null null null esdc_to_integer INTEGER esdc_to_integer(n DOUBLE) -> INTEGER n DOUBLE null null null esdc_to_real REAL esdc_to_real(n DOUBLE) -> REAL n DOUBLE null null null esdc_to_smallint SMALLINT esdc_to_smallint(n DOUBLE) -> SMALLINT n DOUBLE null null null esdc_translate VARCHAR esdc_translate(string VARCHAR, from VARCHAR, to VARCHAR) -> VARCHAR string VARCHAR null null null from VARCHAR null null null to VARCHAR null null null esdc_trim VARCHAR esdc_trim(characters VARCHAR, string VARCHAR) -> VARCHAR characters VARCHAR null null null string VARCHAR null null null gavo_ipix BIGINT gavo_ipix(long REAL, lat REAL) -> BIGINT long REAL null null null lat REAL null null null ivo_epoch_prop_pos POINT ivo_epoch_prop_pos(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> POINT ra DOUBLE null null null de DOUBLE null null null parallax DOUBLE null null null pm_ra DOUBLE null null null pm_de DOUBLE null null null radial_velocity DOUBLE null null null ref_epoch DOUBLE null null null out_epoch DOUBLE null null null ivo_geom_transform VARCHAR ivo_geom_transform(from_sys VARCHAR, to_sys VARCHAR, geo VARCHAR) -> VARCHAR from_sys VARCHAR null null null to_sys VARCHAR null null null geo VARCHAR null null null ivo_hashlist_has INTEGER ivo_hashlist_has(hashlist VARCHAR, item VARCHAR) -> INTEGER hashlist VARCHAR null null null item VARCHAR null null null ivo_hasword INTEGER ivo_hasword(needle VARCHAR, haystack VARCHAR) -> INTEGER needle VARCHAR null null null haystack VARCHAR null null null ivo_healpix_center POINT ivo_healpix_center(hpxOrder INTEGER, hpxIndex INTEGER) -> POINT hpxOrder INTEGER null null null hpxIndex INTEGER null null null ivo_healpix_index BIGINT ivo_healpix_index(hpxOrder INTEGER, point POINT) -> BIGINT hpxOrder INTEGER null null null point POINT null null null ivo_healpix_index BIGINT ivo_healpix_index(hpxOrder INTEGER, long REAL, lat REAL) -> BIGINT hpxOrder INTEGER null null null long REAL null null null lat REAL null null null ivo_histogram INTEGER[*] ivo_histogram(val REAL, lower REAL, upper REAL, nbins INTEGER) -> INTEGER[*] val REAL null null null lower REAL null null null upper REAL null null null nbins INTEGER null null null ivo_interval_overlaps INTEGER ivo_interval_overlaps(a1 DOUBLE, b1 DOUBLE, a2 DOUBLE, b2 DOUBLE) -> INTEGER a1 DOUBLE null null null b1 DOUBLE null null null a2 DOUBLE null null null b2 DOUBLE null null null ivo_nocasematch INTEGER ivo_nocasematch(value VARCHAR, pattern VARCHAR) -> INTEGER value VARCHAR null null null pattern VARCHAR null null null ivo_normal_random REAL ivo_normal_random(mu REAL, sigma REAL) -> REAL mu REAL null null null sigma REAL null null null ivo_simbadpoint POINT ivo_simbadpoint(identifier VARCHAR) -> POINT identifier VARCHAR null null null ivo_string_agg VARCHAR ivo_string_agg(expression VARCHAR, delimiter VARCHAR) -> VARCHAR expression VARCHAR null null null delimiter VARCHAR null null null ivo_to_jd REAL ivo_to_jd(d TIMESTAMP) -> REAL d TIMESTAMP null null null ivo_to_mjd REAL ivo_to_mjd(d TIMESTAMP) -> REAL d TIMESTAMP null null null tap_config tap_schema tap_upload