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