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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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