Editing Corpus/Temporal (section)

== Article versioning ==

Multiple versions of the same article = multiple documents with the same <code>tags.cid</code> (permanent article identity) and different date/date_end ranges.

<syntaxhighlight lang="sql">
-- Get the version of article 1147 CC in force on 2015-06-15
SELECT * FROM corpus.documents
WHERE tags->>'cid' = 'LEGISCTA000006136353'
  AND date <= '2015-06-15'
  AND (date_end IS NULL OR date_end > '2015-06-15')
ORDER BY date DESC LIMIT 1;
</syntaxhighlight>

<code>tags.cid</code> is the permanent identity (CID from LEGI XML, or equivalent). It survives renumbering. Article 1382 and article 1240 have different <code>id</code> values but the relationship is captured in <code>corpus.edges kind=replaces</code>.