Skip site navigation (1) Skip section navigation (2)

Re: greatest/least semantics different between oracle and postgres

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Gregory Stark" <stark(at)enterprisedb(dot)com>, Ben <bench(at)silentmedia(dot)com>, "PostgreSQL General ((EN))" <pgsql-general(at)postgresql(dot)org>
Subject: Re: greatest/least semantics different between oracle and postgres
Date: 2007-06-30 17:34:37
Message-ID: 162867790706301034x4b03f91ax797a7e9a0a8a2038@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
>
> We pretty much ignore the spec's concept of non-error completion
> conditions, but it sounds like Oracle tries to support it.
>
> Anyway, there's no doubt that we can point to the behavior of MAX/MIN
> as defense for what we made GREATEST/LEAST do, so I'm inclined to leave
> their behavior alone, at least until such time as they're actually
> standardized.  But a note in the manual pointing out the difference from
> Oracle seems in order.
>
> BTW, it seems that mysql follows Oracle on this:
>
> mysql> select greatest(1,4,8);
> +-----------------+
> | greatest(1,4,8) |
> +-----------------+
> |               8 |
> +-----------------+
> 1 row in set (0.00 sec)
>
> mysql> select greatest(1,4,null);
> +--------------------+
> | greatest(1,4,null) |
> +--------------------+
> |               NULL |
> +--------------------+
> 1 row in set (0.00 sec)
>
> and if you want a laugh:
>
> mysql> select greatest (1,4,8);
> ERROR 1305 (42000): FUNCTION test.greatest does not exist
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>

Hello

some notes about it

http://bugs.mysql.com/bug.php?id=12791
http://bugs.mysql.com/bug.php?id=15610

Regards
Pavel

In response to

pgsql-general by date

Next:From: Pavel StehuleDate: 2007-06-30 17:36:55
Subject: Re: greatest/least semantics different between oracle and postgres
Previous:From: Bruno Wolff IIIDate: 2007-06-30 17:33:24
Subject: Re: greatest/least semantics different between oracle and postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group