maria-discuss team mailing list archive
Mailing list archive
Re: GSOC 2015 :UDFs returning arrays
On 10.03.15 19:38, Justin Swanhart wrote:
MySQL has no ARRAY data type. In array is basicaly a nested table
data type and MySQL doesn't support nested tables either, except
through dynamic columns. So, a UDF that returned an array could only
be used by other UDF that understand arrays. That isn't very useful.
Strictly speaking server support row type (also kind of array). It can
be used in comparison operations and returned/used in a subquery.