Re: concenation of strings and null values

From: "Dieter Fischer (grid-it)" <dieter(dot)fischer(at)grid-it(dot)ch>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: concenation of strings and null values
Date: 2003-10-07 09:20:14
Message-ID: NDBBJMINGKMICGFKFEPJMEBIDIAA.dieter.fischer@grid-it.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ang Chin Han 2003-10-07 09:21:22 Re: databse design tutorial
Previous Message Nigel J. Andrews 2003-10-07 09:00:40 Re: concenation of strings and null values