Re: expert : SRF returning double[]

From: Rémi Cura <remi(dot)cura(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: expert : SRF returning double[]
Date: 2014-01-16 19:39:03
Message-ID: CAJvUf_t5C-y4pVJUw+Zz7xZ-5y2eK5=ZajEozZYMPNkpZ6-_Mg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

another auto-answer :

Suprisingly ,

result = construct_array(...)
SRF_RETURN_NEXT(funcctx, PointerGetDatum(result));

But Datum memory must be allocated

Cheers,

Rémi-C

2014/1/16 Rémi Cura <remi(dot)cura(at)gmail(dot)com>

> Hey list,
>
> another tricky C function interface problem :
>
> How to write a set returning function, that returns for each row an array?
>
> it seems like the main function SRF_RETURN_NEXT takes Datum and so I can't
> use PG_RETURN_ARRAYTYPE_P().
>
> Shall I encapsulate the array into a composite field (only 1 field : the
> double array)
>
> I looked a lot for an example wihtout success.
>
> Help greatly appreciated,
>
> thanks,
>
> Cheers,
> Rémi-C
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2014-01-16 19:49:17 Re: Need Help to implement Proximity search feature
Previous Message Rémi Cura 2014-01-16 19:25:30 expert : SRF returning double[]