This reminds me of an interview question: I was asked how to get a maximum column from a table without using max. How would you do that?
Select my_column from my_table order by my_column desc limit 1 -- ================================================================== Aaron Bono President Aranya Software Technologies, Inc. http://www.aranya.com We take care of your technology needs. Phone: (816) 695-6071 ================================================================== ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
