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

From Greg Stark
Subject Re: concenation of strings and null values
Date
Msg-id 87brstccxq.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: concenation of strings and null values  (Tino Wildenhain <tino@wildenhain.de>)
List pgsql-general
Tino Wildenhain <tino@wildenhain.de> writes:

> So null (or none, or undefined ...) in most
> languages map to "" (Empty string)

Not in SQL. In SQL null means "unknown". If it's unknown then it's still
unknown when there's something attached to the beginning of it.

--
greg

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Possible bug on insert
Next
From: Bjoern Schmidt
Date:
Subject: some question about column constraints