Skip to main content
S
ShanuGarg1-Visitor
1-Visitor
December 14, 2018
Question

PostgreSQL With Procedural

  • December 14, 2018
  • 1 reply
  • 1797 views

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 

1 reply

Z
zyuan15-Regular Member
5-Regular Member
December 14, 2018

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.

S
ShanuGarg1-VisitorAuthor
1-Visitor
December 14, 2018

So,

In which Persistance Provider It will going to help?

 

Z
zyuan15-Regular Member
5-Regular Member
December 17, 2018

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. 

Terms & ConditionsAccessibility statement