Re: return setof and Temp tables

From: Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com>
To: "Justin B(dot) Kay" <jkay(at)2pattersons(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: return setof and Temp tables
Date: 2006-02-17 06:10:35
Message-ID: 43F568DB.6060902@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Együd Csaba 2006-02-17 07:48:05 importing Npgsql provider into VS2005Express
Previous Message Michael Glaesemann 2006-02-17 05:58:02 Fwd: [pgsql-jp: 36715] Josh Berkus氏の講演MP3