Hi
út 7. 2. 2023 v 3:49 odesílatel Phillip Diffley <pdiffley12@xxxxxxxxx> 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
