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:
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
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.
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 ...
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
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
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
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,