Re: bug or feature, || -operator and NULLs - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: bug or feature, || -operator and NULLs
Date
Msg-id 4536321F.90606@dunslane.net
Whole thread Raw
In response to Re: bug or feature, || -operator and NULLs  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-hackers
Andreas Joseph Krogh wrote:
>> When in doubt, consult the standard ... Oracle's treatment of NULL is
>> known to violate the standard, IIRC. Your measure of correctness seems
>> to be "appears to me more logical", but ours is "complies with the
>> standard".
>>     
>
> I know PG violates the standard in other places and core's favourite argument 
> for doing so is "the standard is braindead here, so we do it our way".
>
>   

In very few places. If you think that an argument like that will make us 
break well established standards-compliant behaviour, you are surely 
sadly mistaken.

cheers

andrew


pgsql-hackers by date:

Previous
From: "Mario Weilguni"
Date:
Subject: Re: bug or feature, || -operator and NULLs
Next
From: Martijn van Oosterhout
Date:
Subject: Re: bug or feature, || -operator and NULLs