Re: Language options for GIN index support functions - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Language options for GIN index support functions
Date
Msg-id CAFj8pRD2sL+n9WpE_d86F7_ZJG7nN6Zd+vsf6CkBko9b=QsJEA@mail.gmail.com
Whole thread Raw
In response to Language options for GIN index support functions  (Phillip Diffley <pdiffley12@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Phillip Diffley
Date:
Subject: Language options for GIN index support functions
Next
From: Laurenz Albe
Date:
Subject: Re: ALTER COLUMN to change GENERATED ALWAYS AS expression?