M
, p_has_attributes boolean )' description text. ♪ ♪ 1 )And I see another identical argument, but I don't want to consider his position.1 is not boolean, it's int. Postgresql obliges the type of data to be monitored and does not allow the leg to be shot with such a simple method. Boolean is true and false, and hand them over.updateProduct(..., true);
By the way, draw attention to the name of the function in the text of the error. lower case, the names of the substance are always in the lower register. Parser led to the bottom register on his own, but it would be better to follow the name scheme in the bottom register and through the lower sub-coding for the facilities in the DSB, update_product♪Well, since I'm still writing the answer, the obvious misunderstanding is:drop function if exists updateProduct();
create or replace function updateProduct
create or replace It'll be fine if it already exists. Changing, for example, the output parameters, won't be able to update, and that drop of function won't help either.create or replace function updateProduct() ...
create or replace function updateProduct(t_id int) ...
create or replace function updateProduct(t_id int, name text) ...
We just created 3 different functionsand not updated the same. ♪ postgresql There may be many functions with one name, but a different set of arguments. That's why. drop function must be given the types of arguments for the function to be removed.