Re: concat returns null

From: Andrew Lazarus &lt; drlaz(at)attglobal(dot)net &gt;
To: abyss &lt; kurjak(at)gmail(dot)com &gt;
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: concat returns null
Date: Tue, 25 Dec 2007 19:49:24 -0800

Peripheral Links

Hello abyss,

Check out the built-in function COALESCE which will do your special-casing for you

Tuesday, December 18, 2007, 3:16:31 AM, you wrote:

>	I don't know if it's bug or feature but select 'test' \|\| null as result returns null, so i need to case second parameter not to concat if it is null...

Best regards,

Home | Main Index | Thread Index