Re: [HACKERS] Documentation tweak for row-valued expressions and null

[Robert Haas]

On Tue, Nov 10, 2015 at 11:10 AM, Jim Nasby  wrote:
> On 7/26/15 8:40 PM, Thomas Munro wrote:
>>
>> I wonder if it might be worth adding a tiny note to the manual to
>> point out that the special logic for " IS [ NOT
>> ] NULL" doesn't apply anywhere else that we handle nulls or talk about
>> [non]-null values in the manual.  See attached.
>
> Yes. This is a common point of confusion.

Agreed.  But I actually don't know whether Thomas's proposed language
matches the actual behavior in every case.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Documentation tweak for row-valued expressions and null

[Jim Nasby]

On 7/26/15 8:40 PM, Thomas Munro wrote:

I wonder if it might be worth adding a tiny note to the manual to
point out that the special logic for " IS [ NOT
] NULL" doesn't apply anywhere else that we handle nulls or talk about
[non]-null values in the manual.  See attached.


Yes. This is a common point of confusion.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Documentation tweak for row-valued expressions and null

[Thomas Munro]

Hi

I wonder if it might be worth adding a tiny note to the manual to
point out that the special logic for row-valued-expression IS [ NOT
] NULL doesn't apply anywhere else that we handle nulls or talk about
[non]-null values in the manual.  See attached.

-- 
Thomas Munro
http://www.enterprisedb.com


note-about-row-is-null.patch
Description: Binary data

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers