Re: Datum problem

On Thu, Nov 09, 2006 at 06:12:08PM +0100, Enrico wrote:
> Hi,
> I'm newbie of programming postgresql sever side,
> I write the function below and when I execute
>
> SELECT (anag_art, 150) AS esistenza from anag_art order by 1;
>
> result is something about this:

Well, you didn't actually call any function, so it just returned the
two parameters as you asked... You have other problems though.

> visualizza_esistenza(PG_FUNCTION_ARGS)
> {
>     HeapTupleHeader  t = PG_GETARG_HEAPTUPLEHEADER(0);
>     int16            limit = PG_GETARG_INT16(1);

An "integer" is not an "int16", so this is wrong, you want INT32

>     bool isnull;
>     Datum esistenza;
>     int16 es;
>
>     esistenza = GetAttributeByName(t, "esistenza", &isnull);
>     es = DatumGetInt16(esistenza);

Possibly same problem here.

>     if (esistenza > limit)
>       PG_RETURN_INT16(es);

You declared you were going to return an int4, yet you're returing
something else.

> }

What are you returning if the if statement doesn't get run?

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.