pl/pgsql via javascript

LabKey Support Forum
pl/pgsql via javascript bront  2013-02-20 04:52
Status: Closed
 
I'm wondering if it is possible to execute a pl/pgsql function via labkey.query?

thanks
 
 
Matthew Bellew responded:  2013-02-20 13:24
Other than the postgres methods documented here

https://www.labkey.org/wiki/home/Documentation/page.view?name=labkeySql

there is not a way to call arbitrary pl/pgsql functions. Do you want to call a postgres built-in function from within a SQL statement? or are you hoping to call an arbitrary custom function (a browser to databse RPC)?

Matt
 
bront responded:  2013-02-20 14:32
I was hoping to call an arbitrary function, but I have since discovered the LABKEY.query.saveRows method. Closer reading revealed that it supports transactions, and I think it will work for what I need.

Many thanks,

b