Skip to main content
ShanuGarg1-Visitor
1-Visitor
Dec 14, 2018 6:24 AM UTC
Question

PostgreSQL With Procedural

Hello everyone,

Can I write my procedural language thing in postgresql??

like this

 

 

SELECT
Asset_id
FROM
"Alerts"
FETCH FIRST [[RowByIndex]] ROW ONLY;

 

and for rowbyidex,  I assigned it as input from property 

4 replies

zyuan15-Regular Member
5-Regular Member
Dec 14, 2018 6:58 AM UTC

You can write stored procedural in External Database, and call it from TWX in SQL services. But if the Postgresql is used as persistence provider, it doesn't help.

Translate
ShanuGarg1-VisitorAuthor
1-Visitor
Dec 14, 2018 8:40 AM UTC

So,

In which Persistance Provider It will going to help?

 

Translate
zyuan15-Regular Member
5-Regular Member
Dec 17, 2018 2:05 AM UTC

The function you want only works in SQL commands, so for any external Database connection, it would work, for any Persistence provider, it won't.   (Meaning that whatever Persistence Provider you choose, it can work in the External Database connection you create for the server)

 

The data connection logic in Persistence Provider is limited by TWX design, you don't have much choice for customization. 

Translate
Terms & ConditionsAccessibility statement