Raymond O'Donnell wrote: > to_char(extract (month from d.dates), 'FMmonth') as month_name, > to_char(extract (day from d.dates), 'FMday') as day_name These formatting patterns are invalid. Check the documentation for the real ones. -- Peter Eisentraut http://developer.postgresql.org/~petere/