Postgres Pro
Downloads
Home   >   mailing lists

Re: string concatenator || and NULL values - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: string concatenator || and NULL values
Date
Msg-id 20040701160037.L41288@megazone.bigpanda.com
Whole thread Raw
In response to string concatenator || and NULL values  (Roberto João Lopes Garcia <roberto@mha.com.br>)
List pgsql-bugs
Tree view 
On Thu, 1 Jul 2004, Roberto [iso-8859-1] Jo=E3o 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."

pgsql-bugs by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: string concatenator || and NULL values
Next
From: Jean-Luc Lachance
Date:
Subject: Re: No rows returned from the SQL query (possible bug)