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
---------------------------------------------------------------
