| commit | 06086baf74c2151ebd70d2e12b8de66fb23600a9 | [log] [tgz] |
|---|---|---|
| author | Scott Ganyo <scott@ganyo.com> | Wed Mar 08 05:10:03 2017 -0800 |
| committer | Scott Ganyo <scott@ganyo.com> | Wed Mar 08 05:10:03 2017 -0800 |
| tree | e1551fd063b329c8a8407609fcb4f88d4f34b426 | |
| parent | 1be60da150c7c072287a1da4b23a755616c1ef7e [diff] |
Use union all - slightly more efficient
diff --git a/api.go b/api.go index dbddea5..216d1bd 100644 --- a/api.go +++ b/api.go
@@ -131,7 +131,7 @@ AND UPPER(a.status) = 'APPROVED' AND c.id = $1 AND c.tenant_id = $2) - UNION + UNION ALL SELECT ap.api_resources, ap.environments,