Posts by Marcos Defina • 123 points

• 0

  votes

  2

  answers

  55

  views

  A: 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…

  database json postgresql sql-update jsonb

  answered 3 years, 4 months ago Marcos Defina 123

• 2

  votes

  2

  answers

  54

  views

  A: 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…

  sql postgresql query

  answered 3 years, 5 months ago Marcos Defina 123

• 4

  votes

  1

  answer

  140

  views

  A: 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:…

  c# unity3d

  answered 5 years, 3 months ago Marcos Defina 123

• 1

  votes

  1

  answer

  77

  views

  A: 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…

  c# unity3d

  answered 5 years, 3 months ago Marcos Defina 123

• 2

  votes

  2

  answers

  289

  views

  A: 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…

  c# unity3d

  answered 5 years, 3 months ago Marcos Defina 123