Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5CJmIE52066 for ; Tue, 12 Jun 2001 15:48:18 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f5CJmEJl007688; Tue, 12 Jun 2001 13:48:14 -0600 Date: Tue, 12 Jun 2001 13:48:14 -0600 From: Roberto Mello To: Andrzej Roszkowski Cc: pgsql-sql@postgresql.org Subject: Re: PL/PGSQL Message-ID: <20010612134814.A7667@cc.usu.edu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.18i X-Archive-Number: 200106/188 X-Sequence-Number: 3444 On Tue, Jun 05, 2001 at 08:18:03AM +0200, Andrzej Roszkowski wrote: > Hi! > I can't find any info about possible data types that can be returned from > procedure. I want to return tuple. When I use OPAQUE as a return type I > get error message that OPAQUE can be only returned from trigger. It is > possible to do this without triggers? A little RTFM'ing wouldn't hurt. Currently you can't return tuples from "regular" PL/pgSQL functions. It heard this functionality will make it in 7.2. -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Death to all fanatics!!!