docs:resource:sql

About

A SQL Stored Function is a function that is

A stored function may return:

select upper('lowercase to uppercase')

Upper function as stored procedure (from this Postgres HowTo) with the JDBC escape syntax

{? = call upper( ? ) }"

SQL Query with the function setoffunc that returns a result set (from this Postgres HowTo)

SELECT * FROM setoffunc()

You create a stored function with a SQL DML Request that contains the SQL statements

You execute a SQL stored function by:

The different way to call and use a function is database dependent.

The below table link to the documentation and to howtos. Tabulify supports by default all database SQL syntax.

Database	Create Function Documentation	HowTo
Postgres	sql-createfunction	SETOF function