Update coderd/database/queries/templateversions.sql

BrunoQuaresma · mafredri · web-flow · commit b16b9b281ee8 · 2022-12-02T11:32:11.000-03:00
Co-authored-by: Mathias Fredriksson &lt;mafredri@gmail.com&gt;
diff --git a/coderd/database/queries/templateversions.sql b/coderd/database/queries/templateversions.sql
@@ -119,7 +119,7 @@ FROM
 WHERE
 	created_at < (
 		SELECT created_at
-		FROM template_versions as tv
+		FROM template_versions AS tv
 		WHERE tv.organization_id = $1 AND tv.name = $2 AND tv.template_id = $3
 	)
 ORDER BY created_at DESC

Original file line number	Diff line number	Diff line change
`@@ -119,7 +119,7 @@ FROM`
`119`	`119`	`WHERE`
`120`	`120`	`created_at < (`
`121`	`121`	`SELECT created_at`
`122`		`- FROM template_versions as tv`
	`122`	`+ FROM template_versions AS tv`
`123`	`123`	`WHERE tv.organization_id = $1 AND tv.name = $2 AND tv.template_id = $3`
`124`	`124`	`)`
`125`	`125`	`ORDER BY created_at DESC`