Thread: Stored Procedures in PostgreSql

Stored Procedures in PostgreSql

From
"Eddie Bortnikov"
Date:

Hi,

 

My question is about creating pre-compiled queries in PostgreSQL, as stored procedures or whatever other way.

1. Is it possible to store prepared statements in the binary form inside the database, so that the SQL compilation would happen only once?

2. If yes, is there any way to do that, other than through embedded SQL?

3. Are SQL functions (created through CREATE FUNCTION …) stored as text or pre-compiled by the DBMS?

 

Regards

 

-- 
-------------------------------------------------------------
Edward Bortnikov
SanGate Systems Ltd.
 
E-mail  eddie@sangate.com
Tel.    972-9-8912163