Postgres Pro
Downloads
Home   >   mailing lists

Re: concenation of strings and null values - Mailing list pgsql-general

From Dieter Fischer (grid-it)
Subject Re: concenation of strings and null values
Date
Msg-id NDBBJMINGKMICGFKFEPJMEBIDIAA.dieter.fischer@grid-it.ch
Whole thread Raw
In response to concenation of strings and null values  (Tino Wildenhain <tino@wildenhain.de>)
Responses Re: concenation of strings and null values  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-general
Tree view 
Hello

> SELECT 'abc'::text || null::text;
>
> The last example looks like a bug,
> but if it is intentionally so, its
> at least very annoying and inconvenient.

NULL means here UNKOWN. You cannot add or concatenate something to an
undefined Value.

Regards

Dieter

pgsql-general by date:

Previous
From: Ang Chin Han
Date:
Subject: Re: databse design tutorial
Next
From: Tino Wildenhain
Date:
Subject: Re: concenation of strings and null values