Postgres Pro
Downloads
Home   >   mailing lists

Re: concatenation with a null column (using ||) nulls the result? - Mailing list pgsql-sql

From Tom Lane
Subject Re: concatenation with a null column (using ||) nulls the result?
Date
Msg-id 921.1144705646@sss.pgh.pa.us
Whole thread Raw
In response to concatenation with a null column (using ||) nulls the result?  (Neil Harkins <nharkins@well.com>)
List pgsql-sql
Tree view 
Neil Harkins <nharkins@well.com> writes:
> Is this standard SQL behavior? 

Yes.  SQL92 6.13 <string value expression>, general rule 2:
        2) If <concatenation> is specified, then let S1 and S2 be the re-           sult of the <character value
expression>and <character factor>,           respectively.
 
           a) If either S1 or S2 is the null value, then the result of the             <concatenation> is the null
value.
    ...
        regards, tom lane

pgsql-sql by date:

Previous
From: Neil Harkins
Date:
Subject: concatenation with a null column (using ||) nulls the result?
Next
From: Alvaro Herrera
Date:
Subject: Re: concatenation with a null column (using ||) nulls the result?