postgresql7.1 select path from sg_libraries; select sg_method__new( :namespace_id, :method, :idl, :idl_style, :proc, :notes, now(), :user_id, :peeraddr, :package_id ); select sg_namespace__new ( :service, :uri, :notes, now(), :user_id, :peeraddr, :package_id ) from dual; select sg_namespace__update( :namespace_id, :service, :uri, :notes, ) from dual; select service, uri, notes from sg_namespaces where namespace_id = :nid select sg_library__new(:path) from dual select path from sg_libraries where library_id = :library_id select 0 + sg_library__delete(:library_id) select 0 + sg_library__update(:library_id,:path)