Thread: Re: [ODBC] [s.hetze@linux-ag.de: PostgreSQL integration Visual Basic,

Michael Meskes wrote:
> into. As far as I understand the problem, the application uses stored
> procedures for each and every select statement. Thus he needs his
> procedures to return the whole query result, which is not doable with
> our functions.

It is in 7.3.

If the return tuple definition is fixed:
instead of:
     exec sp_myproc()
     go
do
     select * from sp_myproc();

If the return tuple definition is *not* fixed:
do
     select * from sp_myproc() as table_alias([col definition list]);

Does this help any? Can he try the 7.3 beta?

Joe

On Fri, Sep 27, 2002 at 09:53:02AM -0700, Joe Conway wrote:
> It is in 7.3.
>
> If the return tuple definition is fixed:
> instead of:
>     exec sp_myproc()
>     go
> do
>     select * from sp_myproc();

That's a great feature to have.

> If the return tuple definition is *not* fixed:
> do
>     select * from sp_myproc() as table_alias([col definition list]);
>
> Does this help any? Can he try the 7.3 beta?

Unfortunately no. They are not willing to use a beta so they are appearantly switching to SAP DB. Sorry.

Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!