Re: [BUGS] string concatenator || and NULL values

2004-07-01 Thread Stephan Szabo
On Thu, 1 Jul 2004, Roberto [iso-8859-1] João 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,

Re: [BUGS] string concatenator || and NULL values

2004-07-01 Thread Bruno Wolff III
On Thu, Jul 01, 2004 at 16:42:29 -0300, Roberto João Lopes Garcia <[EMAIL PROTECTED]> 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