Hi there, I'm having a problem with updating value...
# off-topicd
directlycrazy
10/17/2021, 1:58 PMHi there, I'm having a problem with updating values inside my table. It errors,
{"error":{"code":400,"message":"operator does not exist: text = integer","requestId":""}}g
garyaustin
10/17/2021, 2:33 PMBelieve your are trying to access a number column with text or the opposite.
d
directlycrazy
10/17/2021, 2:34 PMI don't have any number columns in the table though
directlycrazy
10/17/2021, 2:35 PMthese are the columns that are in the table
directlycrazy
10/17/2021, 2:36 PMhere's the query that leads to the error
Copy code
sql
update public.deals set (id,name,platform,link,time,uuid) = (select id,name,platform,link,time,uuid from json_populate_record(null::public.deals, '{\"id\":\"000000000000000172\",\"name\":\"test\",\"platform\":\"test\",\"link\":\"test\",\"time\":\"test\",\"uuid\":\"0e8dc0a1-eb82-42af-a114-c95b310689a2\"}')) where id = 172;g
garyaustin
10/17/2021, 2:38 PMI'm going to guess that id string is getting converted to a number in the process somewhere
d
directlycrazy
10/17/2021, 2:38 PMThat's what i'm thinking too
g
garyaustin
10/17/2021, 2:51 PMYour where id = 172, is an int. You will have to match your string exactly (all the 0's included). Seems like a painful way to do an ID
d
directlycrazy
10/17/2021, 2:59 PMOkay, I will get that changed, thanks for the help.