Graeme Hinchliffe wrote:
>>If monthcurr or username are null, the above will be null.
>>Anything || NULL => NULL.
> AH! thanks sorted it now. That is not the behaviour I would have
> expected :)
> Is there a concatination operator that will not do this? IE
> var1 || var2 || var3
> and var2 is null would result in just var1var3 ?
You could use coalesce(var1,'') || coalesce(var2,'')
Or, wrap that in your own function and create your own operator.
In response to
pgsql-general by date
|Next:||From: Katsaros Kwn/nos||Date: 2004-09-30 09:32:50|
|Subject: Java application and SPI...(?)|
|Previous:||From: Holger Klawitter||Date: 2004-09-30 09:23:17|
|Subject: Re: string is sometimes null ?|