Postgres Pro
Downloads
Home   >   mailing lists

Thread: Language options for GIN index support functions

Language options for GIN index support functions

From
Phillip Diffley
Date:
Hello,

The support functions and operator methods needed to extend a GIN index are documented in C syntax. Do these functions need to be implemented in C, or is there an interface for other languages like PL/pgSQL?

Thanks!
Phillip

Re: Language options for GIN index support functions

From
Pavel Stehule
Date:
Hi


út 7. 2. 2023 v 3:49 odesílatel Phillip Diffley <pdiffley12@gmail.com> napsal:
Hello,

The support functions and operator methods needed to extend a GIN index are documented in C syntax. 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