Re: string concatenator || and NULL values

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.