Home > mailing lists

[GENERAL] Problems with Greatest - Mailing list pgsql-general

From	David G. Johnston
Subject	[GENERAL] Problems with Greatest
Date	February 16, 2017 10:42:36
Msg-id	CAKFQuwYtgjPV49wY6o0vYX0wbo09aOp13vD7oSNCmYXS0BaMXw@mail.gmail.com Whole thread Raw
In response to	[GENERAL] Problems with Greatest (Teddy Schmitz <teddy.schmitz@actuallywedo.com>)
Responses	Re: [GENERAL] Problems with Greatest (Teddy Schmitz <teddy.schmitz@actuallywedo.com>)
List	pgsql-general

On Wednesday, February 15, 2017, Teddy Schmitz <teddy.schmitz@actuallywedo.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.

From: Pavel Stehule
Date: 16 February 2017, 10:41:23
Subject: Re: [GENERAL] Problems with Greatest

From: Teddy Schmitz
Date: 16 February 2017, 10:45:49
Subject: Re: [GENERAL] Problems with Greatest