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:
select * from sp_myproc();
If the return tuple definition is *not* fixed:
select * from sp_myproc() as table_alias([col definition list]);
Does this help any? Can he try the 7.3 beta?
In response to
pgsql-hackers by date
|Next:||From: Roland Roberts||Date: 2002-09-27 17:29:03|
|Subject: Re: [SQL] CURRENT_TIMESTAMP|
|Previous:||From: Tom Lane||Date: 2002-09-27 16:51:50|
|Subject: Re: query speed depends on lifetime of frozen db? |
pgsql-odbc by date
|Next:||From: Neil Conway||Date: 2002-09-28 00:17:42|
|Subject: status of ODBC driver?|
|Previous:||From: JPTrue||Date: 2002-09-27 14:12:25|
|Subject: Re: Text-Varchar Truncation via ODBC|