"Doug Thom" <dthom(at)iagr(dot)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
In response to
pgsql-odbc by date
|Next:||From: Doug Thom||Date: 2007-04-06 17:28:38|
|Subject: Re: Brio returning data through stored procedures. |
|Previous:||From: David Gardner||Date: 2007-04-06 16:42:12|
|Subject: Re: Brio returning data through stored procedures.|