Re: set returning function

From: Kris Jurka <books(at)ejurka(dot)com>
To: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org, airbaggins(at)yahoo(dot)co(dot)uk
Subject: Re: set returning function
Date: 2005-05-09 10:55:48
Message-ID: Pine.BSO.4.56.0505090551590.21377@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, 9 May 2005, Dennis Bjorklund wrote:

> [ I can call sql or C SRFs without FROM, but not plpgsql.]

Trying this in pltcl (while knowing nothing about tcl and the docs not
mentioning any srf support) shows:

CREATE FUNCTION tclset() RETURNS SETOF int AS 'return 0' LANGUAGE pltcl;

SELECT * FROM tclset(); -- works

SELECT tclset(); -- goes into an infinite loop

Kris Jurka

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message AL ELK 2005-05-09 14:05:25 Re: diff value retuns, debug mode and play mode
Previous Message Dennis Bjorklund 2005-05-09 10:21:05 set returning function