postgresql7.4 select as_assessmentsx.name, as_assessmentsx.title, as_assessmentsx.creator_id, as_assessmentsx.description from as_assessmentsx where as_assessmentsx.assessment_id=:assessment_id SELECT distinct as_itemsx.as_item_id, as_itemsx.name, as_itemsx.title, 'radiobutton' as presentation_type FROM as_itemsx