On Mon, 2008-01-07 at 17:03 -0500, Emi Lu wrote: > select ?max?(col1, col2, col3) as result; > will return > > result > ------- > 5 > 8 > 12 > > (3 rows)
8.1 (I believe?) introduced GREATEST(), which does precisely what you're looking for. But if 8.0 is a must, you'll probably have to create your own function to do that. Which should be fairly easy to do if you're working with a static number of columns/data types/etc... - Josh ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster