Postgres Pro
Downloads
Home   >   mailing lists

Re: recursive function returning "setof" - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: recursive function returning "setof"
Date
Msg-id 006b01c24790$072149c0$0200a8c0@SOL
Whole thread Raw
In response to recursive function returning "setof"  (Fritz Lehmann-Grube <lehmannf@math.TU-Berlin.DE>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: Fritz Lehmann-Grube
Date:
Subject: recursive function returning "setof"
Next
From: Mark Stosberg
Date:
Subject: need assistance with multi-row matching expression