Hi there,
I got 2 more. One adding a category and the other mapping a tree. The work is very simple.
Best wishes,
Iuri
Database operation "0or1row" failed (exception ERROR, "ERROR: column "assign_single_p" is of type boolean but expression is of type character
LINE 5: p_assign_single_p, p_require_category_p, p_widge...
^
HINT: You will need to rewrite or cast the expression.
QUERY: insert into category_tree_map
(tree_id, subtree_category_id, object_id,
assign_single_p, require_category_p, widget)
values (p_tree_id, p_subtree_category_id, p_object_id,
p_assign_single_p, p_require_category_p, p_widget)
CONTEXT: PL/pgSQL function "category_tree__map" line 19 at SQL statement
")
ERROR: column "assign_single_p" is of type boolean but expression is of type character
LINE 5: p_assign_single_p, p_require_category_p, p_widge...
^
