Re: MySQL UDF questions

2002-04-11 Thread Georg Richter
On Thursday, 11. April 2002 02:11, Fei Chen wrote: How do I write a UDF to handle a entire tuple, e.g. is it possible to have select my_udf(*) from myTable; ? Parmeters in the UDF could also be fields from a table. Also, is there a way for a UDF to return a data structure, say, a multi

Re: MySQL UDF questions

2002-04-11 Thread Fei Chen
Dear Georg, Thanks for replying. I have read the mysql manual but unfortunately have not been able to find the answer. I realize UDFs can have field names as their parameters, as in select my_udf(fld1, fld2, fld10) from myTable; but here the field names have to be specified explicitly. What I'm

Re: MySQL UDF questions

2002-04-11 Thread Georg Richter
On Thursday, 11. April 2002 10:26, Fei Chen wrote: Dear Georg, * notation. Just as normally I can say select * from myTable; can I write a UDF to handle select my_udf(*) from myTable; ? There is the builtin function select count(*) from myTable; But the manual does not say how this is

MySQL UDF questions

2002-04-10 Thread Fei Chen
Dear all, I'm new to writing UDFs in MySQL so please bear with my couple of questions. How do I write a UDF to handle a entire tuple, e.g. is it possible to have select my_udf(*) from myTable; ? Also, is there a way for a UDF to return a data structure, say, a multi dimensional array? Or do I