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
"start" timestamp without time zone,
"end" timestamp without time zone,
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,
In response to
pgsql-odbc by date
|Next:||From: noreply||Date: 2007-04-06 02:09:05|
|Subject: [ psqlodbc-Bugs-1002827 ] ODBC logging not working in Windows Vista with UAC on |
|Previous:||From: Doug Thom||Date: 2007-04-05 23:05:53|
|Subject: Brio returning data through stored procedures.|