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
