Re: [HACKERS] NULL as an argument in plpgsql functions

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: [HACKERS] NULL as an argument in plpgsql functions
Дата
Msg-id 37F6F437.DD915876@alumni.caltech.edu
обсуждение исходный текст
Ответ на Re: [HACKERS] NULL as an argument in plpgsql functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] NULL as an argument in plpgsql functions
Re: [HACKERS] NULL as an argument in plpgsql functions
Список pgsql-hackers
> probably be better to mark the Const node as having type UNKNOWN instead
> of type 0 (but make_const is not the only place that makes null
> constants this way! we'd need to find all the others...).  But I am not
> sure whether ParseFuncOrColumn would then do the right thing in terms of
> resolving the type of the function; for that matter I'm not real sure
> what the right thing for it to do is.
> Thomas, this stuff is mostly your bailiwick; what do you think?

My recollection is that UNKNOWN usually applies to strings of
unspecified type, while "0" applies to NULL fields. I can put this on
my list to look at later.

Another side issue; any function called with a null parameter will
actually not get called at all! Postgres assumes that a function
called with null must return null, so doesn't bother calling the
routine...
                   - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: 'iscachable' only partially solves premature constant coercion
Следующее
От: "D'Arcy" "J.M." Cain
Дата:
Сообщение: Re: [HACKERS] NULL as an argument in plpgsql functions