10 Mar
2015
10 Mar
'15
8:46 p.m.
Hi! On 10.03.15 19:38, Justin Swanhart wrote:
Hi,
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. [skip]