2

I'm busy setting up a odb file with LibreOffice Base to be used with LibreOffice Calc. The odb file is working fine I can create and save regular queries but it is giving an error when I try to execute a Stored Procedure/Function. When using pgAdmin I can execute the call just fine

select * from funcProduction(current_date, current_date);

This works and returns the data expected but when I try in LibreCalc Base using Queries > Create Query in SQL View, executing the exact same call to the Stored Procedure/Function it fails with an error

Syntax error in SQL statement

I'm not sure why there's an error or even where to find what the error is

TheLovelySausage
  • 3,838
  • 15
  • 56
  • 106

1 Answers1

1

Set the query to Run SQL command directly. This is best for any engine except HSQLDB 1.8.

Related:

Jim K
  • 12,824
  • 2
  • 22
  • 51