Skip site navigation (1) Skip section navigation (2)

Re: Brio returning data through stored procedures.

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Cc: Doug Thom <dthom(at)iagr(dot)net>
Subject: Re: Brio returning data through stored procedures.
Date: 2007-04-06 13:49:53
Message-ID: 46165001.9070608@gmx.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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
> ..... 


In response to

Responses

pgsql-odbc by date

Next:From: Doug ThomDate: 2007-04-06 15:04:12
Subject: Re: Brio returning data through stored procedures.
Previous:From: Ludek FinstrleDate: 2007-04-06 12:37:21
Subject: Re: large Objects through ODBC/ADO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group