Re: [HACKERS] Where are we on stored procedures?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Where are we on stored procedures?
Дата
Msg-id 28071.1109284368@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Where are we on stored procedures?  ("Francisco Figueiredo Jr." <fxjrlists@yahoo.com.br>)
Ответы Re: [HACKERS] Where are we on stored procedures?  ("Francisco Figueiredo Jr." <fxjrlists@yahoo.com.br>)
Список pgsql-jdbc
"Francisco Figueiredo Jr." <fxjrlists@yahoo.com.br> writes:
> Could I add another item?

> Could we have the row count of statements executed inside a
> procedure/function returned to client?

IMHO that request is completely bogus; if the procedure wants to tell
the client that, it's the procedure's responsibility to return the
number as a result.  Doing what you ask (a) would arguably be a security
violation, and (b) the info would be impossible for the client to
interpret in any but the most trivial cases anyway.  Consider for
instance a procedure that contains different queries in the THEN and
the ELSE arms of an IF, or contains loops executed a variable number
of times.  Without access to the results of the control flow tests, the
client could not know which number means what.

            regards, tom lane

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

Предыдущее
От: "Francisco Figueiredo Jr."
Дата:
Сообщение: Re: Where are we on stored procedures?
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: [HACKERS] Where are we on stored procedures?