0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
10 lines
362 B
SQL
10 lines
362 B
SQL
-- name: UpdateAttribute :one
|
|
with updated_attribute as (UPDATE attribute_value
|
|
SET
|
|
val = CASE WHEN @filter_value::bool THEN @value ELSE val END
|
|
WHERE attribute_value.id = @id
|
|
RETURNING id,attribute,val)
|
|
select updated_attribute.id, val, name
|
|
from updated_attribute
|
|
left join attribute on updated_attribute.attribute = attribute.id;
|