I have created a function in the pg database using “CREATE FUNCTION … $$ … $$ LANGUAGE SQL”. It works fine when used in the psql console. In LO Base “SELECT * FROM myfun(…)” results in a syntax error (but, I repeat, not in the psql console). Same thing happens with functions defined in an extension.
I’m having a similar problem trying to use User Defined Functions in queries, but neither LO nor SQL want to proces them… :~(
Help in LibreOffice:
Run SQL command directly
In Native SQL mode you can enter SQL commands that are not interpreted by LibreOffice, but are instead passed directly to the data source. If you do not display these changes in the design view, you cannot change back to the design view.
For native SQL, the SQL string is forwarded directly to the connected database system without a previous evaluation by LibreOffice. For example, if you access a database through an ODBC interface, the SQL string is passed to the ODBC driver and processed by it.
[SQL] Run SQL command directly
Click the icon again to return to normal mode, in which the changes in the New Query Design are synchronized with the permitted changes through SQL.