Re: minimum function
От | PFC |
---|---|
Тема | Re: minimum function |
Дата | |
Msg-id | op.tudvm9d9cigqcu@apollo13 обсуждение исходный текст |
Ответ на | Re: minimum function (Raymond O'Donnell <rod@iol.ie>) |
Список | pgsql-general |
Check out greatest() and least()... (I think ;) On Sat, 23 Jun 2007 18:35:36 +0200, Raymond O'Donnell <rod@iol.ie> wrote: > On 23/06/2007 17:17, Gunther Mayer wrote: > >> Any way I can achieve that on one line? I.e. I want it simpler than >> IF arg1 < arg2 THEN >> RETURN arg1; >> ELSE >> RETURN arg2; >> END IF; > > That looks pretty simple already, but why not enclose it in a pl/pgsql > function - something like: > > create function minimum(a1 integer, a2 integer) returns integer as > $$ > begin > if a1 < a2 then > return a1; > else > return a2; > end if; > end; > $$ > language plpgsql; > > - and then you can call it in one line: > > select minimum(5, 4); > > > Ray. > > > --------------------------------------------------------------- > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > rod@iol.ie > --------------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/
В списке pgsql-general по дате отправления: