Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Wolff III
Subject Re: string concatenator || and NULL values
Date
Msg-id 20040701230219.GA9893@wolff.to
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, Jul 01, 2004 at 16:42:29 -0300,
  Roberto João Lopes Garcia <roberto@mha.com.br> 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:

This isn't a bug. If either operand of || is NULL, then the result is NULL.
You probably want to use the coalesce function to change NULLs to empty
strings.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: VACUUM analyze verbose is skipping tables
Next
From: Stephan Szabo
Date:
Subject: Re: string concatenator || and NULL values