postgresql7.1 select name, description, coalesce(acs_object__name(default_assignee), 'N/A') as assignee_name from ttracker_categories where category_id = :category_id select ttracker_option__option_name(:package_id, 'severity', tt.severity) as pretty_severity, ttracker_option__option_name(:package_id, 'priority', tt.priority) as pretty_priority, tt.ticket_id, tt.subject, to_char(tt.creation_date, 'MM/DD/YYYY HH24:MI') as created, c.state, tt.creation_user as creator_id, acs_object__name(tt.creation_user) as creator_name from wf_cases c, ttracker_tickets tt where tt.category_id = :category_id and c.object_id = tt.ticket_id [ad_dimensional_sql $dimensional] [ad_order_by_from_sort_spec $orderby $table_def] tt.creation_date + '1 days'::interval > now() tt.creation_date + '7 days'::interval > now() tt.creation_date + '30 days'::interval > now()