Thread: Rounding/create C function question

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.

[Charset iso-8859-2 unsupported, filtering to ASCII...]
> 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.

    float8  is  passed by reference (pointer), not by value. Look
    into the existing functions mucking with float8 ...


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #