Re: recursive function returning "setof"

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Fritz Lehmann-Grube" <lehmannf(at)math(dot)TU-Berlin(dot)DE>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: recursive function returning "setof"
Date: 2002-08-19 14:52:22
Message-ID: 006b01c24790$072149c0$0200a8c0@SOL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> The problem is:
> A SQL-Function cannot be recursive because it cannot call itself, and it
can
> perform no loops.
> A PLPGSQL-Function cannot return sets.

It can perform loops. Check the manual- you can do FOR and WHILE loops.
7.3 will be able to return sets from PLPGSQL funcs it seems.

Chris

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Stosberg 2002-08-19 15:21:10 need assistance with multi-row matching expression
Previous Message Fritz Lehmann-Grube 2002-08-19 13:18:57 recursive function returning "setof"