Greetings.

I find myself in need of a minimum() function. This is different from the
min() function, which operates across records; what I need is to be able
to say:

UPDATE foo SET newcol = minimum(field1, field2, field3, field4);

>From what I can tell there is no such beast built in, but I would be happy
to be proved wrong.

Anyway... I can write such a function easily enough in perl, probably
something like:

  my $min=$_[0];
  $min > $_ and $min = $_ foreach @_;
  return $min;

but I can't determine how to allow varying numbers of arguments to be
passed to a function. That is, sometimes I need minimum(arg1, arg2) but
sometimes it's minimum(arg1, arg2, arg3, arg4, arg5), etc.  

Thanks-
Andy Perrin

----------------------------------------------------------------------
Andrew J Perrin - Ph.D. Candidate, UC Berkeley, Dept. of Sociology  
Chapel Hill, North Carolina, USA - http://demog.berkeley.edu/~aperrin
        [EMAIL PROTECTED] - [EMAIL PROTECTED]

Reply via email to