home *** CD-ROM | disk | FTP | other *** search
- /*
- * Earlier releases of Postgres used query rewrite rules to support
- * complex objects. In version 4, full support for Postquel functions
- * has replaced query rewrite rules. Here's how you define a method
- * 'manager' on the 'emp' class, and get complex objects.
- */
-
- define function manager (language = "postquel", returntype = emp)
- arg is (emp)
- as "retrieve (emp.all) where emp.name = dept.mgrname
- and dept.dname = $1.dept"
- \p
-