This patch looks good. I know greater/least are seen as valuable, but do we want decode()? It seems OK to me but I thought there was concern about it in the past because it duplicated some existing functionality.
--------------------------------------------------------------------------- Pavel Stehule wrote: > 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 > > > Content-Description: [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])