Skip to content

Instantly share code, notes, and snippets.

@StanAngeloff

StanAngeloff/non_sequential_ids.sql

Created October 23, 2014 09:54
Show Gist options
  • Save StanAngeloff/b26c7cbc31d75f10d198 to your computer and use it in GitHub Desktop.
Save StanAngeloff/b26c7cbc31d75f10d198 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
non_sequential_ids.sql
SELECT "log"."audit"->>'entity' "entity", "log"."audit"->>'requestId' "requestId", "log".*
FROM "audit_log" "log"
WHERE ("log"."audit"->>'requestId') IS NOT NULL AND NOT EXISTS (
SELECT 1
FROM "audit_log" "log2"
WHERE ("log2"."audit"->>'requestId')::numeric = (("log"."audit"->>'requestId')::numeric - 1)
AND ("log2"."audit"->>'entity') = ("log"."audit"->>'entity')
)
ORDER BY "log"."audit"->>'entity' ASC, "log"."date_logged" ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment