query ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool DISCARD ALL INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool DISCARD ALL INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool DISCARD ALL INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool INSERT INTO current_scores (user_id, task_id, score, answer, result, attempts_clone, attempts_proto, changes, hint_used, solution_used) VALUES ($1 :: uuid, $2 :: uuid, $3 :: DOUBLE PRECISION, $4 :: jsonb, $5 :: jsonb, $6 :: INT, $7 :: INT, $8 :: INT, $9 :: bool, $10 :: bool) ON CONFLICT (user_id, task_id) DO UPDATE SET score = $3 :: DOUBLE PRECISION, answer = $4 :: jsonb, result = $5 :: jsonb, attempts_clone = $6 :: INT, attempts_proto = $7 :: INT, changes = $8 :: INT, hint_used = $9 :: bool, solution_used = $10 :: bool (53 rows)