On 2010-03-02 13:22, Guillaume Yziquel wrote:
Fabian Groffen a écrit :
On 02-03-2010 13:03:26 +0100, Guillaume Yziquel wrote:
Guillaume Yziquel a écrit :
Yes. I discovered them late last night by looking at the php bindings. Page 225 of m5manual.pdf. For instance
The MAL statement 'io.print(1);' returns a table, with one column, but whose only field does not have a name.
What should I choose a MAL statement to be, if I want a similar result, but with a named field?
SQL: select 1;
Thanks.
Using MAL you cannot expect to get resultsets, like SQL does. Hence, I'd say: don't use it.
I'm not using MAL for the pure pleasure of using it.
Nevertheless, there's something I do not understand: isn't SQL compiled to MAL? Then how come you could have resultsets in SQL and not in MAL?
All the best,
It you try explain select 1; you'll see that what it does is call the MAL function sql.exportValue(). The implementation of this function creates the resultset. -- Sjoerd Mullender