Home > mailing lists

Re: getting min/max of two values - Mailing list pgsql-general

From	Pavel Stehule
Subject	Re: getting min/max of two values
Date	September 15, 2007 09:04:21
Msg-id	162867790709150204i66f702c9y45b513e8d0addf9e@mail.gmail.com Whole thread Raw
In response to	getting min/max of two values (rihad <rihad@mail.ru>)
List	pgsql-general

Tree view

2007/9/15, rihad <rihad@mail.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

pgsql-general by date:

From: Ron Johnson
Date: 15 September 2007, 08:58:23
Subject: Re: Locking entire database

From: rihad
Date: 15 September 2007, 11:45:15
Subject: strange TIME behaviour

Re: getting min/max of two values - Mailing list pgsql-general

Previous

Next