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
>
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[] |