On 2/25/24 08:38, Marcos Pegoraro wrote:
Which problem are you trying to solve? You should be reading the
version of
the docs which corresponds to the version you are running. If you
are trying
to figure out an upgrade then the release notes are probably a
better starting
point.
Daniel Gustafsson
All the time we have doubts about what function exists in what version,
or was changed.
IS JSON belongs to 15 or 16, MERGE was done on 14 or 15, as example, are
completely new, so that feature will not run on previous versions.
But sometimes a function is changed a bit or a new easier function is
added, like [1].
Before all those new JSONPATH operators and methods were added, I could
do all those operations and return anything I wanted, but they are a lot
easier.
But if I don't read that page carefully, word by word, I will not see
that that function exists. And this needs to be done on all pages.
What changes were done on CREATE TABLE for version 16 ? Hmm, cool,
STORAGE can be defined at CREATE TABLE stage and not only at ALTER TABLE
anymore.
But to know that I have to read that page carefully, do you understand me ?
So I was thinking of a way to get differences between this and that
versions, and for all doc pages.
Something like we already have on [2], it explicits, this feature was
introduced, this was changed, this does not exist anymore.
Options:
1) One page release notes
https://bucardo.org/postgres_all_versions
Though you will get false positives on search for features that had
fixes in minor releases.
2) Or just read the release notes for the initial release of each major
version.
[1] -
https://www.postgresql.org/docs/devel/functions-json.html#FUNCTIONS-SQLJSON-PATH-OPERATORS <https://www.postgresql.org/docs/devel/functions-json.html#FUNCTIONS-SQLJSON-PATH-OPERATORS>
[2] - https://www.postgresql.org/about/featurematrix/
<https://www.postgresql.org/about/featurematrix/>
regards
Marcos
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
