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

[Back to original message]