Re: store procedure

From: Joel Burton <jburton(at)scw(dot)org>
To: Juan <jcorta(at)tribctas(dot)gba(dot)gov(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: store procedure
Date: 2001-04-09 17:28:33
Message-ID: Pine.LNX.4.21.0104091327390.3882-100000@olympus.scw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 9 Apr 2001, Juan wrote:

> hello list,
> im new in stores procedure and i want to do one writed in pl/pqsl, that it
> returns a table.
> im 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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2001-04-09 17:31:51 Re: PostgreSQL on Windows (again)
Previous Message Justin Clift 2001-04-09 17:07:01 Re: linux/bsd