Re: BUG #5753: Existing Functions No Longer Work

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: BUG #5753: Existing Functions No Longer Work
Дата
Msg-id
23279.1289686429@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
BUG #5753: Existing Functions No Longer Work "Vince Maxey" <vamax27@yahoo.com>
Re: BUG #5753: Existing Functions No Longer Work Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5753: Existing Functions No Longer Work vince maxey <vamax27@yahoo.com>
Re: BUG #5753: Existing Functions No Longer Work Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5753: Existing Functions No Longer Work vince maxey <vamax27@yahoo.com>
Re: BUG #5753: Existing Functions No Longer Work Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #5753: Existing Functions No Longer Work Pavel Stehule <pavel.stehule@gmail.com>
vince maxey  writes:
> I am running my test procs from the pgAdminIII GUI.  Is my syntax wrong to 
> execute the function?  If I run select test_proc1(3), I do get the correct 
> result which is a column header (test_proc1 integer) and a value (2).  So why 
> wouldn't I get a 6-column result set when running select test_proc(2) ?

Because those functions return the name of a cursor, not the result of
fetching from the cursor.  The same would have been true in any prior
release too, so I'm not sure why you're having trouble with 9.0 and
not before.  You sure you haven't dropped a level of indirect fetch
from your client code?

			regards, tom lane
В списке pgsql-bugs по дате отправления
От: vince maxey
Дата:
От: Yeb Havinga
Дата:
FAQ