> I need a query to get data that is 6 months older than "today" or when that > query is run. WHERE table.date < current_date-interval'6 months' -- Mike Nolan ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match