M
M
Max Serge2021-10-17 17:56:36
PostgreSQL
Max Serge, 2021-10-17 17:56:36

Storing and executing stored queries in a psql sqlite database table)?

Information is catastrophically small, but there are examples of such an approach.
https://stackoverflow.com/questions/17317198/how-t... (cm)
Pitfalls in the form of arbitrarily executed requests have already been studied and stopped (requests are formulated by the system). Stored procedures won't work in my case. (view also aside)
Idea:
There is a certain number of hard-coded procedures that perform the calculation of specific parameters. There is a sql query in the form of text, which contains the actions between the procedures described above.
Alya "'((Select * from positivepoint($1)) - (Select * from negativepoint($1))) / (Select * from allpoint($1)::float))'"
At the output, we get the result of this action.
The problem is that there is no information on how to execute this request with passing parameters to it.
If there are simpler options, I will not refuse either. Ask.

And it won’t work to form it in code and send it to the database, minus the performance from frequent handling of data transfers.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question