Revision 8581
Added by ben leinfelder almost 11 years ago
| src/upgrade-db-to-2.4.0-postgres.sql | ||
|---|---|---|
| 24 | 24 |
AND id.guid = sm.guid |
| 25 | 25 |
AND sm.obsoleted_by IS NOT null |
| 26 | 26 |
UNION ALL |
| 27 |
SELECT newer.guid, newer.obsoleted_by
|
|
| 28 |
FROM systemMetadata newer
|
|
| 29 |
JOIN q
|
|
| 30 |
ON q.obsoleted_by = newer.guid
|
|
| 27 |
SELECT newer.guid, newer.obsoleted_by |
|
| 28 |
FROM systemMetadata newer |
|
| 29 |
JOIN q |
|
| 30 |
ON q.obsoleted_by = newer.guid |
|
| 31 | 31 |
) |
| 32 | 32 |
SELECT guid, obsoleted_by |
| 33 | 33 |
INTO current_documents |
Also available in: Unified diff
adjust whitespace for consistency