[SQL] Internal functions documented

2003-01-01 Thread Daniel Bruce Lynes
I've noticed a lot of the functions that are documented for libpg are also stored in pg_proc. Are these functions additionally callable from pl/pgsql? And if so, are they documented for pl/pgsql anywhere, or do we need to make educated guesses as to the parameters for them under pl/pgsql? For

[SQL] Compiling pl/pgsql functions?

2003-01-03 Thread Daniel Bruce Lynes
Through preliminary examination, it appears stored procedures using pl/pgsql in PostgreSQL 7.3 are interpreted, rather than compiled? When we insert a stored function into PostgreSQL, the syntax check is not done until execution, and only on the branch/path of execution, not on the entire funct