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

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: [ODBC] [s.hetze@linux-ag.de: PostgreSQL integration Visual Basic,
Дата
Msg-id 3D948CEE.3040105@joeconway.com
обсуждение исходный текст
Ответы Re: [ODBC] [s.hetze@linux-ag.de: PostgreSQL integration Visual Basic, SQLProcedureColumns]  (Michael Meskes <meskes@postgresql.org>)
Список pgsql-hackers
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





В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masaru Sugawara
Дата:
Сообщение: Re: About connectby() again
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: [GENERAL] Performance while loading data and indexing