Re: Language options for GIN index support functions

Hi

út 7. 2. 2023 v 3:49 odesílatel Phillip Diffley <pdiffley12(at)gmail(dot)com>
napsal:

> Hello,
>
> The support functions and operator methods needed to extend a GIN index
> are documented in C syntax
> <https://www.postgresql.org/docs/current/gin-extensibility.html>. Do
> these functions need to be implemented in C, or is there an interface for
> other languages like PL/pgSQL?
>

PL/pgSQL can use only function that are callable from SQL - they have to
use Version1 calling convention
https://www.postgresql.org/docs/current/xfunc-c.html#id-1.8.3.13.7

GIN support functions use classic C functions, that means they can be
called only from C and languages that support C calls. PL/pgSQL doesn't do
this.

PL/pgSQL is just glue for SQL - it can be used for implementation of some
customer business tasks, but it cannot be (almost) used for Postgres
extending.

Regards

Pavel

> Thanks!
> Phillip
>