return setof and Temp tables

From: "Justin B(dot) Kay" <jkay(at)2pattersons(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: return setof and Temp tables
Date: 2006-02-17 05:13:02
Message-ID: 716B12278E234246B3217E1ED755393A0A2356@SBServer.2Pattersons.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have looked around and found that you can use return setof in a
function to return a result set, but can you use a temp table as the
setof target? I build a temp table using various select statements and
then try to return the result as a recordset. I get an error: type t1
does not exist.

If this is not possible, is there some alternative way to do this? I am
trying to translate what was done in a ms sql database.

Justin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mmaclennan 2006-02-17 05:38:07 connecting to pgsql
Previous Message Neil Conway 2006-02-17 04:29:28 Re: How do I use the backend APIs