Re: PL/PGSQL

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: Andrzej Roszkowski <thomas(at)polcard(dot)com(dot)pl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PL/PGSQL
Date: 2001-06-12 19:48:14
Message-ID: 20010612134814.A7667@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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!!!

In response to

  • PL/PGSQL at 2001-06-05 06:18:03 from Andrzej Roszkowski

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-06-12 20:03:21 Re: update from another table
Previous Message Oleg Bartunov 2001-06-12 19:38:17 Re: Bit Mapping operation