Commit114797d

committed

Correcting query

Signed-off-by: Danny Kopping <danny@coder.com>

1 parent387b557 commit114797dCopy full SHA for 114797d

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 1 deletion

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -36,7 +36,7 @@ RETURNING *;`
`36`	`36`	`WITH acquiredAS (`
`37`	`37`	`UPDATE`
`38`	`38`	`notification_messages`
`39`		`-SET queued_seconds= GREATEST(0, EXTRACT(EPOCHFROM (NOW()- updated_at)))::FLOAT,`
	`39`	`+SET queued_seconds=CEIL(GREATEST(0, EXTRACT(EPOCHFROM (NOW()- updated_at))))::INTEGER,`
`40`	`40`	`updated_at= NOW(),`
`41`	`41`	`status='leased'::notification_message_status,`
`42`	`42`	`status_reason='Leased by notifier'\|\|sqlc.arg('notifier_id')::uuid,`

Comments

(0)