Re: string concatenator || and NULL values

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Roberto João Lopes Garcia <roberto(at)mha(dot)com(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: string concatenator || and NULL values
Date: 2004-07-01 23:03:29
Message-ID: 20040701160037.L41288@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


On Thu, 1 Jul 2004, Roberto [iso-8859-1] Joo Lopes Garcia wrote:

> When I use string concatenator || and there are fields of type date whith NULL values
> the result is an enpty string. Please see example:

The result is NULL. This is the correct result.

"If either S1 or S2 is the null value, then the result of the
<concatenation> is the null value."

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Claudio Natoli 2004-07-02 00:47:49 Re: build failed using MINGW32 / MSys
Previous Message Bruno Wolff III 2004-07-01 23:02:19 Re: string concatenator || and NULL values