BUG #4509: array_cat's null behaviour is inconsistent

Поиск
Список
Период
Сортировка
От Kevin Field
Тема BUG #4509: array_cat's null behaviour is inconsistent
Дата
Msg-id 200811031807.mA3I7mbg038076@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4509: array_cat's null behaviour is inconsistent  (Peter Eisentraut <peter_e@gmx.net>)
Re: BUG #4509: array_cat's null behaviour is inconsistent  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4509
Logged by:          Kevin Field
Email address:      kev@brantaero.com
PostgreSQL version: 8.3.4
Operating system:   Windows Server 2003 SP2
Description:        array_cat's null behaviour is inconsistent
Details:

Section 9.2 in the docs say, 'The ordinary comparison operators yield null
(signifying "unknown") when either input is null.'  This applies to other
operators too.  For example, the result of tacking an unknown value onto a
known one is unknown, because you don't know what exactly you just tacked
on.  So

   select null::text || 'hello';

...returns NULL, which makes sense.  But then this

   select array_cat(null::integer[], '{3}'::integer[]);

...doesn't return NULL, which it should, for consistency.

Kev

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Behavior change of FK info query
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Behavior change of FK info query