sinceEnterpriseDB does suport CREATE PROCEDUREto be compatible with Oracle. In PostgreSQL 8.4, this may change. Check outPavel Stehule: Stacked Recordsetand
SSIS 2005: Disconnected recordsets are not available from ODBC connections SSIS 2008 - Exec SQL Task - IsQueryStoredProcedure grayed out SSIS 2008 R2 - How to add columns to an existing mapping with destination DB table SSIS 2008, The name 'Dts' does not exist in the current context ssis ...
post_docs(docs,chunk_size) - returning recordset of status codes? or just true/false? how to deal with the case where there are 5 chunks and the first 2 sucseed but the 3rd fails? is it possible to rollback a transaction in postgres and give the function oldocs and newdocs then a po...
we need to define the structure of the output. The benefit of an alias recordset is that you can have all sorts of queries use the same function as long as your calling query knows the expected structure. The downside is that you have to note the expected structure which quickly...