Problems with Greatest

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Teddy Schmitz <teddy(dot)schmitz(at)actuallywedo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Problems with Greatest
Date: 2017-02-16 04:42:36
Message-ID: CAKFQuwYtgjPV49wY6o0vYX0wbo09aOp13vD7oSNCmYXS0BaMXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, February 15, 2017, Teddy Schmitz <teddy(dot)schmitz(at)actuallywedo(dot)
com <javascript:_e(%7B%7D,'cvml','teddy(dot)schmitz(at)actuallywedo(dot)com');>> wrote:
>
> select greatest(max(t1.id), max(t2.id)) from t1, t2;
>
>
I seriously doubt that the greatest function is a larger contributor to run
time than the cross join between t1 and t2.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Teddy Schmitz 2017-02-16 04:45:49 Re: Problems with Greatest
Previous Message Pavel Stehule 2017-02-16 04:41:23 Re: Problems with Greatest