arrays in ADQL/TAP

[Walter Landry]

Markus Demleitner <msdemlei at ari.uni-heidelberg.de> wrote:
> As a first step, I think it'd be useful if people running the various
> database backends could report how much trouble the respective
> features would be for their backends.  If some of the major ones have
> no array support at all, I'd say it's a non-starter right there,
> otherwise we could think of a subset of features that won't cause
> havoc in our ADQL grammar.
> 
> So -- 
> 
> Postgres obviously wouldn't have trouble with any of this.
> 
> SQLite has no native array support I'm aware of, but if I had a
> SQLite backend I suspect I could fairly easily inject the necessary
> facilities at least for the basic function set (though I've never
> actually done it, so this might be vain overconfidence).

Oracle seems to have both fixed and variable sized arrays

  http://stackoverflow.com/questions/7012625/oracle-pl-sql-how-to-create-a-simple-array-variable
  http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/05_colls.htm

Informix seems to allow fixed sized arrays up to dim=3

  http://aubit4gl.sourceforge.net/aubit4gldoc/4glreference/pages/4GLREFARRAY00000479.htm

Cheers,
Walter Landry