Ask Your Question
0

Is it possible to call user-defined DB functions in BASE? [closed]

asked 2013-06-24 19:41:24 +0200

nholtz gravatar image

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.

:-( :-( :-(

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 14:48:15.340239

Comments

I'm having a similar problem trying to use User Defined Functions in queries, but neither LO nor SQL want to proces them... :~(

guigonse gravatar imageguigonse ( 2014-04-12 22:03:39 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2013-06-24 21:36:54 +0200

m.a.riosv gravatar image

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.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-06-24 19:41:24 +0200

Seen: 812 times

Last updated: Oct 28 '13