Re: return setof and Temp tables - Mailing list pgsql-general

From Tony Caduto
Subject Re: return setof and Temp tables
Date
Msg-id 43F568DB.6060902@amsoftwaredesign.com
Whole thread Raw
In response to return setof and Temp tables  ("Justin B. Kay" <jkay@2pattersons.com>)
List pgsql-general
Justin B. Kay wrote:

> 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.



I have done it by returning a ref cursor to the temp table.

I believe there are some ref cursor examples in the docs, if you can't
find any let me know and I can send you a example.

--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql
http://www.amsoftwaredesign.com

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: How do I use the backend APIs
Next
From: Együd Csaba
Date:
Subject: importing Npgsql provider into VS2005Express