PostgreSQL With Procedural

[ShanuGarg]

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 

[zyuan1]

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.

[ShanuGarg]

So,

In which Persistance Provider It will going to help?

[zyuan1]

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. 

[slangley]

Hi @ShanuGarg.

If one of the previous responses provided by @zyuan1 answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

Thank you for using our Community!

Regards.

--Sharon