Re: Out parameters handling

Поиск
Список
Период
Сортировка
Искать
От
Jonah H. Harris
Тема
Re: Out parameters handling
Дата
Msg-id
36e682920903061349u16f87f2dyf79971a6450d5f5@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Out parameters handling Asko Oja <ascoja@gmail.com>
Re: Out parameters handling "Jonah H. Harris" <jonah.harris@gmail.com>
Re: Out parameters handling "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Out parameters handling Alvaro Herrera <alvherre@commandprompt.com>
Re: Out parameters handling Robert Haas <robertmhaas@gmail.com>
Re: Out parameters handling Josh Berkus <josh@agliodbs.com>
Re: Out parameters handling Dimitri Fontaine <dfontaine@hi-media.com>
Re: Out parameters handling Tom Lane <tgl@sss.pgh.pa.us>
Re: Out parameters handling Dimitri Fontaine <dfontaine@hi-media.com>
Re: Out parameters handling Pavel Stehule <pavel.stehule@gmail.com>
Re: Out parameters handling Asko Oja <ascoja@gmail.com>
Re: Out parameters handling Robert Haas <robertmhaas@gmail.com>
Re: Out parameters handling Rod Taylor <rod.taylor@gmail.com>
Re: Out parameters handling Robert Haas <robertmhaas@gmail.com>
Re: Out parameters handling Tom Lane <tgl@sss.pgh.pa.us>
Re: Out parameters handling Robert Haas <robertmhaas@gmail.com>
Re: Out parameters handling Tom Lane <tgl@sss.pgh.pa.us>
Re: Out parameters handling Robert Haas <robertmhaas@gmail.com>
Re: Out parameters handling Rod Taylor <rod.taylor@gmail.com>
Re: Out parameters handling Gregory Stark <stark@enterprisedb.com>
Re: Out parameters handling Tom Lane <tgl@sss.pgh.pa.us>
Re: Out parameters handling Pavel Stehule <pavel.stehule@gmail.com>
Re: Out parameters handling Marko Kreen <markokr@gmail.com>
Re: Out parameters handling Josh Berkus <josh@agliodbs.com>
Re: Out parameters handling Tom Lane <tgl@sss.pgh.pa.us>
Re: Out parameters handling Pavel Stehule <pavel.stehule@gmail.com>
Re: Out parameters handling Rod Taylor <rod.taylor@gmail.com>
Re: Out parameters handling Pavel Stehule <pavel.stehule@gmail.com>
Re: Out parameters handling Ryan Bradetich <rbradetich@gmail.com>
Re: Out parameters handling Tom Lane <tgl@sss.pgh.pa.us>
Re: Out parameters handling Ryan Bradetich <rbradetich@gmail.com>
Re: Out parameters handling Pavel Stehule <pavel.stehule@gmail.com>
On Fri, Mar 6, 2009 at 4:29 PM, Asko Oja <ascoja@gmail.com> wrote:
It was one of my worst Friday's finding out that this brain dead implementation of out parameters had been part of fuck up again.

:)
 

This time we did notice it two days too late.
I wish for a way to use out parameters in functions only through some predefined prefix like in triggers new and old. Means i  would like to limit referencing to out parameters to one prefix only defined in the beginning of declare section of stored procedure.
It really sucks what kind of mistakes you can pass to production unknowingly. I would much prefer a way to prevent such nonsense.
Here was the case where out parameters were with same names with select into field names resulting in null outcome. Just yesterday we had similar case with update statement.

Well, it's a problem with the language not parsing things correctly and doing, in many cases, brain-dead replacements.  I don't know of any developer using OUT parameters that doesn't run into this problem at one time or another :(

--
Jonah H. Harris, Senior DBA
myYearbook.com

В списке pgsql-hackers по дате отправления
От: Asko Oja
Дата:
Сообщение: Out parameters handling
От: Lawrence, Ramon
Дата:
FAQ