Re: store procedure - Mailing list pgsql-general

From Joel Burton
Subject Re: store procedure
Date
Msg-id Pine.LNX.4.21.0104091327390.3882-100000@olympus.scw.org
Whole thread Raw
In response to store procedure  ("Juan" <jcorta@tribctas.gba.gov.ar>)
List pgsql-general
On Mon, 9 Apr 2001, Juan wrote:

> hello list,
> i�m new in stores procedure and i want to do one writed in pl/pqsl, that it
> returns a table.
> i�m accesing from odbc.
>
> how the store procedure returns the table to process it in the programming
> languaje(vb)? what type it returns?

Juan --

At present, there is no reasonable way for a procedure to return a result
set (like a table).

Could you write a view that returns the data that you want?

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: linux/bsd
Next
From: Tony Grant
Date:
Subject: Re: ongoing holy grail thread