Hello, 

I sended version with only LEAST and GREATEST
http://archives.postgresql.org/pgsql-patches/2005-06/msg00185.php

this patch contains diff files for NEXT_DAY and LAST_DAY function too, 
which I think are generally usefull.

There is duplicity with CASE. 

Regards
Pavel

On Tue, 21 Jun 2005, Bruce Momjian wrote:

> 
> 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
> 
> 


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to