Never worked with Brio, but have you defined a data-type in pgsql that
your function would be returning? Something like:
CREATE TYPE "myType" AS
("name" text,
"start" timestamp without time zone,
"end" timestamp without time zone,
error text);
ALTER TYPE "myType" OWNER TO "me";
then the function definition would start off like:
CREATE OR REPLACE FUNCTION "getData"()
RETURNS SETOF "myType" AS
.....
Doug Thom wrote:
>
> Hello, all,
>
> I am wondering if anybody knows how to return data to Brio through
> ODBC from a function. If you are (or were) an Oracle user you may be
> familiar with defining a ref cursor type and including that as an OUT
> parameter. Brio then picks it up through ODBC and collects the results.
>
> When I tried this in many different ways in Postgres the best I could
> get returned was either “<unnamed portal x>” where x increments for
> the number of times I tried it or what I passed in when I used the
> method that allows me to have the calling procedure name the cursor.
> But no data.
>
> If anybody has run into this challenge I would love to hear if you
> were or were not successful. I’d really like to hear you were
> successful, of course, but if there is no way to do it then there’s no
> point me wasting any more time with it.
>
> Thank you,
>
> -Doug
>