select max(col1) from table union all select max(col2) from table union all select max(col3) from table
No, this is not what I prefer; it makes complicate query.
Would the following work also? SELECT MAX( GREATEST( col1, col2, col3 ) ) FROM TABLE;
I would prefer this func. Unfortunately, the current version I have 8.02(http://www.postgresql.org/docs/8.0/static/functions-conditional.html) does not support this func I am afraid :(
Thanks ! Ly. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster