Re: concat returns null - Mailing list pgsql-jdbc

From tivvpgsqljdbc@gtech-ua.com
Subject Re: concat returns null
Date
Msg-id 4767AEC3.1080908@gtech-ua.com
Whole thread Raw
In response to concat returns null  (abyss <kurjak@gmail.com>)
List pgsql-jdbc
abyss 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...
It's and SQL feature that neither specific to JDBC nor PostgreSQL. Most
SQL functions return null if any of parameters is null.


pgsql-jdbc by date:

Previous
From: abyss
Date:
Subject: concat returns null
Next
From: Tore Halset
Date:
Subject: Re: find foreign key name