Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15862; Mon, 25 Jan 93 09:40:49 -0800
Message-Id: <9301251740.AA15862@postgres.Berkeley.EDU>
From: <mao@postgres.berkeley.edu>
Subject: Re: handling of complex return types in functions
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Mon, 25 Jan 93 08:20:17 PST.
             <9301251620.AA15219@postgres.Berkeley.EDU> 
Date: Mon, 25 Jan 93 09:41:57 PST

In message <9301251620.AA15219@postgres.Berkeley.EDU> you write:

> * define function OwnedClasses (language="postquel",
>                                 returntype = setof char16)
>           arg is (oid)
>         as "retrieve (c.relname) from c in pg_class
>         where c.relowner= $1 "
> 
> The problem comes up when i try to get *all* the fields in a query, eg:
> 
> * retrieve (x = OwnedClasses(8::oid)) \g
> 
> The interpreter complains about assigning a complex type to a
> variable:

this is a known bug in 4.0.1; unfortunately, you can only examine a single
column of tuples returned by postquel functions.  we hope to remedy this
in a future release of the software.
					mike