06-27-14, 11:25 #1Registered User
- Join Date
- Apr 2002
- Westwood, MA, USA
Unanswered: Are PL/pgSQL procs without explicit Function declarations possible ?
In Oracle PL/SQL you can write a SQL script that has procedure control structures (IF/THEN/ENDIF, etc.) without having to explicitly define a function or proc. You need only surround it with DECLARE/BEGIN/END statments. In effect, this gives you "temporary" procs. Can this be done in PostgreSQL 9.x ?Joe Petronio, Sr. DB Architect