Posts by Marcos Defina • 123 points
5 posts
-
0
votes2
answers55
viewsA: Postgresql change an element of a JSON column
The third parameter of jsonb_set() expects a jsonb object, but vc is passing text. Cast a cast of substring(json_avaliado::json->>'url', 2, (length(json_avaliado::json->>'url')-2)) for…
-
2
votes2
answers54
viewsA: Take only the first record of each condition
You can add using the array_agg function and access the index of the item you want, if you sort by some column with timestamp is perfect. select id_uni_sching, (array_agg(id_sching order by…
-
4
votes1
answer140
viewsA: how to change the material of an onclick object
You need to reference their Renderer Material Component in your script... And as soon as they’re clicked, you switch this stuff to another one of your liking. In Prefab you do something like this:…
-
1
votes1
answer77
viewsA: I cannot change the center of rotation of a Tilemap (Unity + C#)
I don’t know much about Tilemap, but I’ve had a lot of problems with UI rotation. What I can suggest is a trick to help you with that. Create a GameObject, position it in the center of your tilemap…
-
2
votes2
answers289
viewsA: Add Object to a List with C#
You are not adding Watermelon to your list, so the second Update If will never be true. There are a few more logic errors in your script, which I’m sorry I couldn’t help but be without Unity, and in…