Postgres Pro
Downloads
Home   >   mailing lists

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

From Teddy Schmitz
Subject Re: [GENERAL] Problems with Greatest
Date
Msg-id SINPR0101MB16942546A9A0567FF618E34B835A0@SINPR0101MB1694.apcprd01.prod.exchangelabs.com
Whole thread Raw
In response to [GENERAL] Problems with Greatest  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view

Thanks for the link Pavel,  that makes perfect sense now.


Teddy

From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Thursday, February 16, 2017 12:42:36 PM
To: Teddy Schmitz
Cc: pgsql-general@postgresql.org
Subject: [GENERAL] Problems with Greatest
 
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. 

		
	


	

					

					





	

	pgsql-general by date:
	
	

	
	

		
			

	        	

	       			Previous
	    		

	    		
	From:
	"David G. Johnston"

	Date:
	



	Subject:
	[GENERAL] Problems with Greatest
 

	    	

	    
	    
	    
			

	        	

	       			Next
	    		

	    		
	From:
	Thomas Kellerer

	Date:
	



	Subject:
	Re: [GENERAL] Problems with Greatest