Re: Handling NULL records in plpgsql

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Handling NULL records in plpgsql
Дата
Msg-id 603c8f070810251159s2948f337g380e5c9e2b73352c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Handling NULL records in plpgsql  (Decibel! <decibel@decibel.org>)
Ответы Re: Handling NULL records in plpgsql  ("Dave Gudeman" <dave.gudeman@gmail.com>)
Список pgsql-hackers
> I really think we should have a way of telling if a array/row/record
> variable is actually set to something, and I'm pretty sure that should be
> unrelated to whether all the elements in it happen to be null.

+1.  Also, can whatever syntax we introduce by something relatively
concise?  Code that looks nice when you write "=" does not look as
nice when you write "IS NOT DISTINCT FROM".  I'm almost inclined to
suggest using functional notation rather than dreaming up a new "IS
WHATEVER" syntax.

> And the IS
> NOT NULL case seems exceptionally broken. I think it's extremely confusing
> to have it behave differently than NOT blah IS NULL.

-1.  This is obviously a trap for the unwary but I think we're stuck with it.

...Robert


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

Предыдущее
От: "Robert Haas"
Дата:
Сообщение: Re: Regression in IN( field, field, field ) performance
Следующее
От: "Dave Gudeman"
Дата:
Сообщение: Re: Handling NULL records in plpgsql