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,
but are ugly and neefective, or impossible (function DECODE rotate type of
args). All functions share code.
David, please, can you enhance documentation?
pokus=# select least(1,2,3,4);
least
-------
1
(1 row)
pokus=# select greatest(1,2,3,4);
greatest
----------
4
(1 row)
pokus=# select decode('c','a',2,1);
decode
--------
1
Best regards
Pavel Stehule