David Fetter wrote:
On Thu, Jun 02, 2005 at 05:41:46PM +0200, Pavel Stehule wrote:
My next patch is implementation least and greatest functions. If
will  possible I prefere contrib for it, but it's inpossible. ...

BTW, the thing about least() and greatest() (basically the row-wise
versions of min() and max()) has come up before, and they would be
quite handy :)

At least for integers, I think I've done something similar using
the intarray contrib; like this...

  select (sort_desc(array[1,2,3])) [1]; -- for greatest
  select (sort(array[2,1,3])) [1];      -- for least

(if I understand right what the greatest function does
in O*). For other types something similar should work,
but I guess the sort function would need to be written.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to