That sounds like a hack. Is limit a SQL-99 standard? Is there are another way to do this?select max(date_sent) from table; would equal select date_sent from broadcast_history order by date_sent DESC limit 1;
Sorry to take over your topic, Collin. Thanks, Yasir ---------------------------(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