Subject | Re: Standard Deviation : SQRT UDF |
---|---|
Author | Mario |
Post date | 2005-07-15T01:19:34Z |
Thanks. Executed this SQRT UDF in IBConsole as suggested and it works
well with the STDDEV SP, which now includes the sqrt function.
As I am planning to move my databases from IB to Firebird, what would
be the equivalent SQRT UDF code (see below) to execute in FB ?
Regards,
Mario
--- In firebird-support@yahoogroups.com, Adomas Urbanavicius
<adomas@i...> wrote:
well with the STDDEV SP, which now includes the sqrt function.
As I am planning to move my databases from IB to Firebird, what would
be the equivalent SQRT UDF code (see below) to execute in FB ?
Regards,
Mario
--- In firebird-support@yahoogroups.com, Adomas Urbanavicius
<adomas@i...> wrote:
> > DECLARE EXTERNAL FUNCTION SQRT
> > DOUBLE PRECISION
> > RETURNS DOUBLE PRECISION BY VALUE
> > ENTRY_POINT 'IB_UDF_sqrt' MODULE_NAME 'ib_udf';
> I think,you should execute this ddl in sql editor, then commit, and udf
> function would be available in any procedure/sql sentence.
> No need (error) it to redeclare in SP.
>
> Adomas