Posted by Jim Michaels on 01/10/06 07:49

the syntax is wrong. the function must be compiled in a shared library
first an declared with SONAME.
27.2.2. CREATE FUNCTION/DROP FUNCTION Syntax
CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL}
SONAME shared_library_name

DROP FUNCTION function_name
maybe this has changed in version 5. I am using 4.1."rokshill"
<noid.noid@gmail.com> wrote in message
news:dn9oa5$nrb$1@news.dialog.net.pl...
> like that:
>
> create function fn_rand() returns float
>
> begin
>
> return rand()
>
> end
>
>
>
> Msg 443, Level 16, State 1, Procedure fn_rand, Line 3
>
> Invalid use of side-effecting or time-dependent operator in 'rand' within
> a function.
>
>
>
> what is a problem ?
>
>
>
> thanks for help
>
>

[Back to original message]