Rounding/create C function question - Mailing list pgsql-general

Hi,

 I need some custom rounding function (say 1 or two decimal points),
what would be the simplest way to make one?

- Robert



P.S. I tried to create one in C like

    #include <string.h>
    #include "postgres.h"

    double tst5(double x) {
        return x; // ... whatever needed
    }

and compiled it with (on RadHat 6.1, PG 6.5.3)

    gcc -I/usr/include/pgsql -fPIC -shared
        -o libeucto.so.0.0.2 -Wl,-soname,libeucto.so.0.0.2 eucto_round.c

    CREATE FUNCTION tst5(float8) RETURNS float8
        AS '/mnt/lotrando_c/projekty/eucto/bin/libeucto.so.0.0.2' LANGUAGE
'c';

This works as long as the function is int4/int4, but for float8 'backend
terminated abnormally'. Thanks for any help.