Posts by Erenilson Alencastro • 1 point
2 posts
-
-3
votes3
answers737
viewsA: Make an "Update" with sum of a number that is as character
Solved, I did it this way: CREATE TEMPORARY SEQUENCE Code START WITCH 361; AFTERWARD: UPDATE product set code= nextval('product code');
-
-1
votes3
answers737
viewsQ: Make an "Update" with sum of a number that is as character
I need to perform a update summed in a table whose column is of the type text. Example: UPDATE produto SET codigo = 'codigo'+ 1; I have the following return: UPDATE produto SET codigo = 'codigo'+ 1;…