Re: Get the max(value1, value2, value3) from a table

On Jan 7, 2008 4:37 PM, Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
>
> >
> >> 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.

Generally speaking when you have to make complicated queries to get
simple answers, then it's likely you have a normalization issue. IF
col1, col2, col3 were all a single column in an external table the
answer would likely fall out a little simpler.

But honestly, that's not a real complex query. PostgreSQL handles far
more complex queries for me everyday with hardly a murmer..