Skip to content

Instantly share code, notes, and snippets.

@dorkness-io

dorkness-io/select_into.sql

Created April 9, 2020 13:48
Show Gist options
  • Save dorkness-io/cf75eaa710005a41c4bcdfd77c448e16 to your computer and use it in GitHub Desktop.
Save dorkness-io/cf75eaa710005a41c4bcdfd77c448e16 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_into.sql
drop table if exists weekly_issues;
select
p.pkey || '-' || ji.issuenum AS issue_key
,ji.summary
,ji.reporter
,ji.created
into temp weekly_issues
from jiraissue ji
join project p
on ji.project = p.id
where ji.created >= now() - interval '1 week';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment