SELECT gl_glossar__new(
null ,
:owner_id ,
:title ,
:comment ,
:source_category_id ,
:target_category_id ,
'gl_glossar' ,
current_timestamp ,
:user_id ,
'' ,
null ,
:package_id
) as glossar_id
UPDATE gl_glossars
SET
title = :title ,
comment = :comment ,
source_category_id = :source_category_id ,
target_category_id = :target_category_id
WHERE glossar_id = :glossar_id
SELECT gl_glossar_term__new(null, :glossar_id , :comment , :source_text , :target_text , :dont_text , null , current_timestamp , :user_id , :user_ip , null , :package_id ) as term_id
UPDATE acs_objects
SET modifying_user = :user_id ,
last_modified = current_timestamp
WHERE acs_object_id = :term_id
UPDATE gl_glossar_terms
SET
source_text = :source_text ,
target_text = :target_text ,
dont_text = :dont_text ,
comment = :comment
WHERE term_id = :term_id
postgresql
7.2