Home > mailing lists

select NULL||'abc' returns empty string (or NULL) - Mailing list pgsql-general

From	Holger Marzen
Subject	select NULL\|\|'abc' returns empty string (or NULL)
Date	February 27, 2002 09:33:43
Msg-id	Pine.LNX.4.44.0202271223030.9979-100000@bluebell.marzen.de Whole thread Raw
Responses	Re: select NULL\|\|'abc' returns empty string (or NULL) Re: select NULL\|\|'abc' returns empty string (or NULL) Re: select NULL\|\|'abc' returns empty string (or NULL) Re: select NULL\|\|'abc' returns empty string (or NULL)
List	pgsql-general

Tree view

I suppose that PostgreSQL insists that a NULL value cannot be
concatenated with a string. Can I cast this somehow? I noticed that
feature when I did a

select * from tab where col1||col2 ilike '%bla%'

and it did't find rows where one of the columns was NULL. Any ideas for
workarounds?

--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1

pgsql-general by date:

From: Jean-Michel POURE
Date: 27 February 2002, 08:27:01
Subject: MySQL

From: Alexey Borzov
Date: 27 February 2002, 09:54:52
Subject: Re: select NULL||'abc' returns empty string (or NULL)

select NULL||'abc' returns empty string (or NULL) - Mailing list pgsql-general

Previous

Next