From: | "Doug Thom" <dthom(at)iagr(dot)net> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Brio returning data through stored procedures. |
Date: | 2007-04-06 15:04:12 |
Message-ID: | A9D51A18173BD043BC843DAFB9CA48EC9A7A06@VMAIL.iagr.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello, David, Andreas,
Thank you for the suggestions. The challenge is that I need a ref cursor
because it is some arbitrary amount of data coming back from the server
in a cursor. Your suggestion shows a defined row but I do not know what
the row looks like so I cannot define a type beforehand.
However, your comments have me wondering if there is a different route I
can take. Is there anything that is a 'generic row of data'? I see the
type "record" and I'm going to give that a try.
Thanks again for the prompt response and ideas!
-Doug
-----Original Message-----
From: Andreas [mailto:maps(dot)on(at)gmx(dot)net]
Sent: Friday, April 06, 2007 9:50 AM
To: pgsql-odbc(at)postgresql(dot)org
Cc: Doug Thom
Subject: Re: [ODBC] Brio returning data through stored procedures.
Hi Doug
I dont know Brio either but keep in mind that tables and views are
allready defined types which you could use here.
So if your procedure just selects a few rows from a view or table but
should return all collumns from the source you don't have to define a
return type.
David Gardner schrieb:
> 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
> .....
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2007-04-06 15:40:49 | [ psqlodbc-Bugs-1000467 ] Can't use (b)lobs with Omnis Studio v4 |
Previous Message | Andreas | 2007-04-06 13:49:53 | Re: Brio returning data through stored procedures. |