Search Postgresql Archives

minimum function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi there,

I'm busy writing a trigger function in pl/pgsql and find myself in need of a minimum() function. I can't see how the builtin min() aggregate function can be of any use here since all I want to do is something like

SELECT minimum(5,6) => 5

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;

Gunther


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux