Skip site navigation (1) Skip section navigation (2)

Re: concat returns null

From: tivvpgsqljdbc(at)gtech-ua(dot)com
To: abyss <kurjak(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: concat returns null
Date: 2007-12-18 11:28:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.

In response to

pgsql-jdbc by date

Next:From: Tore HalsetDate: 2007-12-18 14:43:24
Subject: Re: find foreign key name
Previous:From: abyssDate: 2007-12-18 11:16:31
Subject: concat returns null

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group