writing and executing a simple PostgreSQL procedure and function
writing and executing a simple PostgreSQL procedure and function
(OP)
In My Java application I have used all queries in server side (Tomcat). But it's performance seems to be too slow. So I would like to convert all the complex queries in to Stored procedure and that will be running in database server.
Could you please help me in writing and executing a simple PostgreSQL procedure and function using simple SQL.
Thanks with regards
Jayakumar
Could you please help me in writing and executing a simple PostgreSQL procedure and function using simple SQL.
Thanks with regards
Jayakumar
RE: writing and executing a simple PostgreSQL procedure and function
You can take a look at the following link of functions and stored procedures that have been contributed.
http://www.brasileiro.net/postgres/cookbook/
Leland F. Jackson, CPA
Software - Master (TM)
https://www.smvfp.com
Nothing Runs Like the Fox