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

Re: DIfference between max() and greatest() ?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Ruben Gouveia <rubes7202(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: DIfference between max() and greatest() ?
Date: 2008-09-12 07:24:51
Message-ID: 48CA1943.3030701@gmx.net (view raw or flat)
Thread:
Lists: pgsql-sql
Ruben Gouveia wrote:
> What is the difference between these two. I know that max() is an 
> aggregate function

... and greatest() is a normal single-row function.

One works vertically, one works horizontally, if that helps you. :-)

Or max() is like sum() and greatest is like +.


In response to

pgsql-sql by date

Next:From: Hengky LieDate: 2008-09-12 09:22:51
Subject: Pls Hlp: SQL Problem
Previous:From: Bart DegryseDate: 2008-09-12 07:10:08
Subject: Re: DIfference between max() and greatest() ?

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