Re: [PATCHES] Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)

2005-06-23 Thread Tom Lane
Pavel Stehule <[EMAIL PROTECTED]> writes: + /* If any argument is null, then result is null (for GREATEST and LEAST)*/ Are you sure about that? The only reference I could find says that these functions are not strict in Oracle: http://download-east.oracle.com/otn_hosted_do

[PATCHES] Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)

2005-06-06 Thread Pavel Stehule
Hello This patch contains three oracle users missing functions. But I hope can be usefull for all PostgreSQL users (users vote me ;-) Certainly LEAST and GREATEST, which has not analogy. Using of DECODE is similar CASE, but with some differences. There exist some workarounds in plpgsql,