Search Postgresql Archives

Re: coalesce for null AND empty strings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ferdinand Gassauer wrote:
* looking through Google it IS a concern for many others and thus this function should be distributed as default.

The mere fact that something is requested does not imply that the request should be accepted. I'm sure there's a name for this fallacy, but I can't think of it just now.

This is especially true when the common request stems from common ignorance.

Richard Huxton wrote:
Hmm - I see it coming up occasionally, but usually where people are misusing NULLs.

This is why the request should be rejected. NULL has a specific semantic, and it is most emphatically not the same as an empty string.

It is not wise to mess with the fundamental mathematics of SQL. Get used to the fact that NULL is not empty string; embrace the fact and learn to love it.

-- Lew


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux