Quick Links

concat returns null

From:	abyss <kurjak(at)gmail(dot)com>
To:	pgsql-jdbc(at)postgresql(dot)org
Subject:	concat returns null
Date:	2007-12-18 11:16:31
Message-ID:	8f60d3bd0712180316r52dd88b9j4e092ee7b1a03d06@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-jdbc

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...

Responses

Re: concat returns null at 2007-12-18 11:28:03 from tivvpgsqljdbc
Re: concat returns null at 2007-12-26 03:49:24 from Andrew Lazarus

Browse pgsql-jdbc by date

	From	Date	Subject
Next Message	tivvpgsqljdbc	2007-12-18 11:28:03	Re: concat returns null
Previous Message	Christian Schröder	2007-12-18 10:47:11	Missing fields in getColumns() result