Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
SELECT ivoid FROM rr.res_table WHERE table_name LIKE '%.epn_core'

This query returns 82 192 results, but there are duplication and redundant results. This query is thus not optimal.

...

Code Block
languagesql
SELECT ivoid FROM rr.res_table WHERE table_utype = 'ivo://vopdc.obspm/std/epncore#schema-2.0' 

27 results

This utype is deprecated.

...

Code Block
languagesql
SELECT ivoid FROM rr.res_table WHERE table_utype = 'ivo://ivoa.net/std/epntap#table-2.0' 

133 results


A query matching all EPNcore versions would be: 

Code Block
languagesql
SELECT ivoid FROM rr.res_table FROM rr.res_table WHERE table_utype likeLIKE 'ivo://vopdc.obspm/std/epncore%' OR table_utype LIKE 'ivo://ivoa.net/std/epntap#table-2.%epntap#table%'

which returns with 48 178 results at the time of writing.

...