Subject: handling of complex return types in functions (correction)

From: [email-masked] (Ken Manheimer)
Date: Mon, 25 Jan 93 08:51:11 -0800

Darn - one correction for my previous message.  The function
definition for OwnedClasses, which i use in my experiment with complex
returns, is as follows:

 define function OwnedClasses (language="postquel",
                                 returntype = setof pg_class)
        arg is (oid)
        as "retrieve (c.all) from c in pg_class
                             where c.relowner= $1 "\g

This is the function i actually used in my tests, and in fact the
correct one to use.  The difference from the one i posted is retrieval
of c.all, rather than c.relowner.  c.relowner does not make sense for
a returntype of pg_class.

Ken again.