or, from the "stupid tricks" category: SELECT n.user_id, max(lpad(extract(epoch from n.modified_date),12,'0') || ' ' || note) FROM notes n GROUP by n.user_id
i am not *really* suggesting this! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
