Skip site navigation (1) Skip section navigation (2)

array_cat null reasoning

From: Kev <kevinjamesfield(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: array_cat null reasoning
Date: 2008-10-27 18:08:35
Message-ID: (view raw or whole thread)
Lists: pgsql-general

I'm a bit confused as to the logic of nulls.  I understand that null
is to represent an unknown value.  So it makes sense that 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';

...returning NULL makes sense.  But then why doesn't

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

...also return null?  Somehow it's known what the result is when
combining an unknown array with a known one, but not when combining an
unknown text with a known one?  Doesn't this seem inconsistent?  If it
does seem inconsistent, should I be careful how to code because this
might change in the future?



pgsql-general by date

Next:From: Anderson dos Santos DondaDate: 2008-10-27 18:09:31
Subject: Execute Shell script after insert
Previous:From: Simon RiggsDate: 2008-10-27 17:16:11
Subject: Re: [HACKERS] Hot Standby utility and administrator functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group