Re: getting min/max of two values

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: rihad <rihad(at)mail(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: getting min/max of two values
Date: 2007-09-15 09:04:15
Message-ID: 162867790709150204i66f702c9y45b513e8d0addf9e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2007/9/15, rihad <rihad(at)mail(dot)ru>:
> How can I efficiently return the minimum/maximum of two given
> expressions? Like SELECT MYMIN(a+b-c,d+e*f).
>
> Thanks.

Hello

use function GREATEST (maximim) or LEAST (minimum)

http://www.postgresql.org/docs/8.2/interactive/functions-conditional.html#AEN13148

Regards
Pavel Stehule

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey Myers 2007-09-15 11:24:26 Re: NOT NULL Issue
Previous Message Ron Johnson 2007-09-15 08:54:49 Re: Locking entire database