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

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 w

Re: MySQL UDF questions

2002-04-10 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