OnlyPHP

2013年5月23日

postgresql 触发器的使用

摘要： 39.9. Trigger ProceduresPL/pgSQL can be used to define trigger procedures. A trigger procedure is created with the CREATE FUNCTION command, declaring it as a function with no arguments and a return type of trigger. Note that the function must be declared with no arguments even if it expects to recei 阅读全文

posted @ 2013-05-23 09:56 OnlyPHP 阅读(223) 评论(0) 推荐(0) 编辑

postgresql 存储过程使用

摘要： Return more than one row of data from PL/pgSQL functionsFrom PostgreSQL wikiJump to: navigation, searchby Stephan SzaboLast updated 4th April 2003 PostgreSQL 7.3 now supports a much more flexible system for writing set returning functions (SRFs) that when combined with some of the new function permi 阅读全文

posted @ 2013-05-23 09:53 OnlyPHP 阅读(581) 评论(0) 推荐(0) 编辑

导航