POSTGRESQL: PERFORM

[Aesth]

PostgreSQL has a PERFORM statement for calling a function and ignoring the results, similar to calling a procedure. When I try to call SQLPage, I get:Parsing failed: SQLPage couldn't understand the SQL file. Please check...
Is this a bug or a feature? Of course, there's a workaround for fetching the result into a temporary variable or table, but I don't want to complicate the logic.

[lovasoa]

@Aesth this is a valid question and the answer may be useful to others, let's answer it here. In general, it's probably better to add a comment below your questions than editing them so that they appear blank.

so to anyone stumbling on this: the best way to use PL/pgSQL in sqlpage is to create a stored procedure in a migration and then call it from sqlpage.

https://www.postgresql.org/docs/current/sql-createprocedure.html
https://www.postgresql.org/docs/current/plpgsql-statements.html