writing and executing a simple PostgreSQL procedure and function

Jayadoor · Oct 29, 2002

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

Leland123 · Oct 30, 2002

Hi Jayadoor,

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

writing and executing a simple PostgreSQL procedure and function

Jayadoor

Programmer

Leland123

Programmer

Similar threads

Part and Inventory Search

Sponsor