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:

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

2005-06-21 Thread Pavel Stehule
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

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

2005-06-21 Thread Bruce Momjian
Pavel Stehule wrote: Hello, I sended version with only LEAST and GREATEST http://archives.postgresql.org/pgsql-patches/2005-06/msg00185.php OK, did you remove DECODE for a reason? this patch contains diff files for NEXT_DAY and LAST_DAY function too, which I think are generally usefull.

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

2005-06-21 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: Oh, and I personally think DECODE is fine, even if it partly duplicates something we already have. I was just asking to make sure everyone else was OK before I applied it. I would rather not have a useless variant spelling of CASE ...

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

2005-06-21 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Oh, and I personally think DECODE is fine, even if it partly duplicates something we already have. I was just asking to make sure everyone else was OK before I applied it. I would rather not have a useless variant spelling of

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

2005-06-21 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: OK, I will apply the LEAST/GREATEST parts and see if others can argue for decode(). Actually, I'd like to review the patch before it goes in --- if anyone's looked at the code, I saw no comments about it ... regards, tom lane

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

2005-06-21 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: OK, I will apply the LEAST/GREATEST parts and see if others can argue for decode(). Actually, I'd like to review the patch before it goes in --- if anyone's looked at the code, I saw no comments about it ... No, no one

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

2005-06-21 Thread Pavel Stehule
this patch is last Pavel On Tue, 21 Jun 2005, Bruce Momjian wrote: Pavel Stehule wrote: 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,