Re: Brio returning data through stored procedures. - Mailing list pgsql-odbc

From Tom Lane
Subject Re: Brio returning data through stored procedures.
Date
Msg-id 14927.1175880445@sss.pgh.pa.us
Whole thread Raw
In response to Re: Brio returning data through stored procedures.  ("Doug Thom" <dthom@iagr.net>)
List pgsql-odbc
"Doug Thom" <dthom@iagr.net> writes:
> So I would be doing something like:

> --Do the thing that builds the query.
> Select query
>   Into query-string
>   From table-that-has-query;

> Open cursor for query-string;

> Return cursor;
> --End pseudo code

I think you're looking for OPEN cursor FOR EXECUTE in plpgsql.
See the "cursor operations" part of the plpgsql manual.

            regards, tom lane

pgsql-odbc by date:

Previous
From: David Gardner
Date:
Subject: Re: Brio returning data through stored procedures.
Next
From: "Doug Thom"
Date:
Subject: Re: Brio returning data through stored procedures.