Stored Procedures in PostgreSql - Mailing list pgsql-general

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