postgresql7.4 SELECT cc_stream__name(:stream_id) SELECT map.uos_id, rev.year_id, rev.core_id, rev.note FROM cc_stream_uos_map map, cc_stream_uos_map_rev rev WHERE map.map_id = :map_id AND rev.map_rev_id = map.latest_revision_id SELECT cc_stream_uos_map_rev__new ( NULL, :map_id, :year_id, :core_id, :note, now(), :modifying_user, :modifying_ip )