Sending Results From One Function As Input into Another Function

From: Jeff Adams <Jeff(dot)Adams(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: Sending Results From One Function As Input into Another Function
Date: 2011-09-22 15:04:21
Message-ID: 001b01cc7938$e888a320$b999e960$%Adams@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

I need to send the results (SETOF RECORDS) from one function into another
function, to produce another result (SETOF RECORDS). I am not quite sure how
to do get this done. The first function filters a large table down a more
manageable dataset. I want to send the results of this first function to
another function, where computations are performed. I could combine into a
single function, but I would lose some flexibility that I would like to
maintain by keeping the two functions separate. Preliminary research
suggests that cursors might be the way to go, but I am not too experienced
with the use of cursors and was unable to find good examples. Any help would
be greatly appreciated...

Jeff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2011-09-22 15:15:43 Re: Materialized views in Oracle
Previous Message Szymon Guz 2011-09-22 14:57:24 Re: why VOLATILE attribute is required?