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: 4767AEC3.1080908@gtech-ua.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-jdbc by date

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