maria-discuss team mailing list archive

[Oleksandr Byelkin <sanja@xxxxxxxxxxxxxxxx>]

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]