Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions) - Mailing list pgsql-patches

From Pavel Stehule
Subject Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)
Date
Msg-id Pine.LNX.4.44.0506062351480.16856-200000@kix.fsv.cvut.cz
Whole thread Raw
Responses Re: Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic
Re: Function's LEAST, GREATEST and DECODE (Oracle vararg polymorphic functions)
List pgsql-patches
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




Attachment

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Implement support for TCP_KEEPCNT, TCP_KEEPIDLE, TCP_KEEPINTVL
Next
From: Bruce Momjian
Date:
Subject: Re: using strxfrm for having multi locale/please vote for