fix: add comment about @status being a text

BrunoQuaresma · BrunoQuaresma · commit 677cb6f9e958 · 2022-04-28T14:38:31.000Z
diff --git a/coderd/database/queries/users.sql b/coderd/database/queries/users.sql
@@ -87,6 +87,8 @@ WHERE
 	END
 	-- Filter by status
 	AND CASE
+		-- @status needs to be a text because it can be empty, If it was
+		-- user_status enum, it would not.
 		WHEN @status :: text != '' THEN (
 			status = @status
 		)

Original file line number	Diff line number	Diff line change
`@@ -87,6 +87,8 @@ WHERE`
`87`	`87`	`END`
`88`	`88`	`-- Filter by status`
`89`	`89`	`AND CASE`
	`90`	`+ -- @status needs to be a text because it can be empty, If it was`
	`91`	`+ -- user_status enum, it would not.`
`90`	`92`	`WHEN @status :: text != '' THEN (`
`91`	`93`	`status = @status`
`92`	`94`	`)`