Skip to content

Commit cbca654

Browse files
committed
fixup sql spacing
1 parent c0bbd83 commit cbca654

File tree

1 file changed

+14
-14
lines changed

1 file changed

+14
-14
lines changed

coderd/database/queries/groups.sql

Lines changed: 14 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -28,25 +28,25 @@ FROM
2828
WHERE
2929
true
3030
AND CASE
31-
WHEN @organization_id:: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
32-
groups.organization_id = @organization_id
33-
ELSE true
31+
WHEN @organization_id:: uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
32+
groups.organization_id = @organization_id
33+
ELSE true
3434
END
3535
AND CASE
3636
-- Filter to only include groups a user is a member of
3737
WHEN @has_member_id::uuid != '00000000-0000-0000-0000-000000000000'::uuid THEN
3838
EXISTS (
39-
SELECT
40-
1
41-
FROM
42-
-- this view handles the 'everyone' group in orgs.
43-
group_members_expanded
44-
WHERE
45-
group_members_expanded.group_id = groups.id
46-
AND
47-
group_members_expanded.user_id = @has_member_id
48-
)
49-
ELSE true
39+
SELECT
40+
1
41+
FROM
42+
-- this view handles the 'everyone' group in orgs.
43+
group_members_expanded
44+
WHERE
45+
group_members_expanded.group_id = groups.id
46+
AND
47+
group_members_expanded.user_id = @has_member_id
48+
)
49+
ELSE true
5050
END
5151
;
5252

0 commit comments

Comments
 (0)