Re: SQL99 ARRAY support proposal

OK, let's look at these more closely:

> >> array_push(anyarray, anyelement) returns anyarray

The standard spelling for that appears to be
somearray || ARRAY[element]
which also has the nice property that it is commutative.

> >> array_pop(anyarray) returns anyelement

That appears to mean that you return somearray[0] and alter the array as a
side effect. How do you plan to do that?

> >> array_subscript(anyarray, int) yields anyelement

That's just somearray[x], no?

> >> singleton_array(anyelement) returns anyarray

That's ARRAY[element].

> >> split(text, text) returns text[]
> >> - split string into array on delimiter
> >> implode(text[], text) returns text
> >> - join array elements into a string using given string delimiter

I can live with these, but perhaps we should choose some not-so-generic
names.

--
Peter Eisentraut peter_e(at)gmx(dot)net