Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15443; Mon, 25 Jan 93 08:51:11 -0800
Date: Mon, 25 Jan 93 08:51:11 -0800
Message-Id: <9301251651.AA15443@postgres.Berkeley.EDU>
From: klm@nist.gov (Ken Manheimer)
Subject: handling of complex return types in functions (correction)
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

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.