Re: minimum function

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(at)iol(dot)ie
---------------------------------------------------------------