On Jan 7, 2008 4:37 PM, Emi Lu <[EMAIL PROTECTED]> 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.. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
