Re: [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle
Date
Msg-id 42BC0D8C.5070900@dunslane.net
Whole thread Raw
In response to Re: [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:

>[ moving to -hackers for a wider audience ]
>
>Today's issue: should the GREATEST/LEAST functions be strict (return
>null if any input is null) or not (return null only if all inputs are
>null, else return the largest/smallest of the non-null inputs)?
>
>  
>

My initial reaction was to say "not strict", and since that's apparently 
what Oracle does that reinforces it for me.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] O_DIRECT for WAL writes
Next
From: Mike Rylander
Date:
Subject: Re: [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)