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@iol.ie
---------------------------------------------------------------