|
Posted by J.O. Aho on 01/10/06 08:49
Jim Michaels wrote:
> the syntax is wrong. the function must be compiled in a shared library
> first an declared with SONAME.
>> create function fn_rand() returns float
>>
>> begin
>>
>> return rand()
>>
>> end
>>
-- for just in case it's off
SET GLOBAL log_bin_trust_function_creators =1;
-- the function
delimiter //
CREATE FUNCTION fn_rand() RETURNS DECIMAL
BEGIN
RETURN RAND();
END;
//
delimiter ;
//Aho
Navigation:
[Reply to this message]
|