Commit67f73a7

committed

change query

1 parent1b574f8 commit67f73a7Copy full SHA for 67f73a7

File tree

-5

lines changed

-5

lines changed

Lines changed: 9 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -107,9 +107,13 @@ WHERE`
`107`	`107`	`ANDt.deprecated='';`
`108`	`108`
`109`	`109`	`-- name: UpdatePresetsLastInvalidatedAt :many`
`110`		`-UPDATE template_version_presets`
`111`		`-SET last_invalidated_at= $1`
`112`		`-WHERE template_version_id= (`
`113`		`-SELECT active_version_idFROM templatesWHERE id= $2`
`114`		`-)`
	`110`	`+UPDATE`
	`111`	`+template_version_presets tvp`
	`112`	`+SET`
	`113`	`+last_invalidated_at= $1`
	`114`	`+FROM`
	`115`	`+templates t`
	`116`	`+WHERE`
	`117`	`+t.id= $2`
	`118`	`+ANDtvp.template_version_id=t.active_version_id`
`115`	`119`	`RETURNING*;`

Comments

(0)