pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feeddocumenting divergence from the SQL spec
4+ messages / 3 participants
[nested] [flat]
* documenting divergence from the SQL spec
@ 2020-02-14 16:05 Dave Cramer <davecramer@postgres.rocks>
0 siblings, 1 reply; 4+ messages in thread
From: Dave Cramer @ 2020-02-14 16:05 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
We have a section in the main docs for conformance
https://www.postgresql.org/docs/12/features.html
And then this https://wiki.postgresql.org/wiki/PostgreSQL_vs_SQL_Standard for
divergence.
I'd like to see the divergence section put into the main docs so that it is
easier to find.
Thoughts ?
Dave Cramer
www.postgres.rocks
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: documenting divergence from the SQL spec
@ 2020-02-14 16:26 Tom Lane <tgl@sss.pgh.pa.us>
parent: Dave Cramer <davecramer@postgres.rocks>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2020-02-14 16:26 UTC (permalink / raw)
To: Dave Cramer <davecramer@postgres.rocks>; +Cc: pgsql-docs@lists.postgresql.org
Dave Cramer <davecramer@postgres.rocks> writes:
> We have a section in the main docs for conformance
> https://www.postgresql.org/docs/12/features.html
> And then this https://wiki.postgresql.org/wiki/PostgreSQL_vs_SQL_Standard for
> divergence.
> I'd like to see the divergence section put into the main docs so that it is
> easier to find.
The individual statement reference pages already have sections for
standards divergences. Admittedly, that framework doesn't help for
discrepancies that can't be tied to a statement type ... but I don't
think we should throw in duplicative material of this sort. It's
tough enough to keep one instance of the info up-to-date. So I'd
want to see some structure for this that respects that existing
set of information.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: documenting divergence from the SQL spec
@ 2020-02-14 16:43 Dave Cramer <davecramer@postgres.rocks>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Dave Cramer @ 2020-02-14 16:43 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-docs@lists.postgresql.org
On Fri, 14 Feb 2020 at 11:26, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Dave Cramer <davecramer@postgres.rocks> writes:
> > We have a section in the main docs for conformance
> > https://www.postgresql.org/docs/12/features.html
> > And then this
> https://wiki.postgresql.org/wiki/PostgreSQL_vs_SQL_Standard for
> > divergence.
> > I'd like to see the divergence section put into the main docs so that it
> is
> > easier to find.
>
> The individual statement reference pages already have sections for
> standards divergences. Admittedly, that framework doesn't help for
> discrepancies that can't be tied to a statement type ... but I don't
> think we should throw in duplicative material of this sort. It's
> tough enough to keep one instance of the info up-to-date. So I'd
> want to see some structure for this that respects that existing
> set of information.
>
>
I get that we don't want duplicative material.
Would it be possible to tag the current documentation in such a way to
extract the
divergences where they were already documented at the statement level ?
Then everything that isn't tied to a statement could be documented manually
in the divergence
section ?
The problem I am trying to address is that it is very difficult to know all
the places I should look for documentation.
The wiki seems to be the dumping ground for everything that doesn't fit
into the documentation.
The problem with this is that if you don't know it is documented there it
is very difficult to find.
Dave Cramer
www.postgres.rocks
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: documenting divergence from the SQL spec
@ 2020-02-14 16:50 Alvaro Herrera <alvherre@2ndquadrant.com>
parent: Dave Cramer <davecramer@postgres.rocks>
0 siblings, 0 replies; 4+ messages in thread
From: Alvaro Herrera @ 2020-02-14 16:50 UTC (permalink / raw)
To: Dave Cramer <davecramer@postgres.rocks>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-docs@lists.postgresql.org
On 2020-Feb-14, Dave Cramer wrote:
> The wiki seems to be the dumping ground for everything that doesn't fit
> into the documentation.
> The problem with this is that if you don't know it is documented there it
> is very difficult to find.
Would it help to have some sort of index? The simplest I can think of
is to add <indexterm> for each Nonstandard Clauses section, with
something like
<primary>Nonstandard Clauses</primary>
<secondary>in SELECT</secondary>
so that in the index you'd get a list of all commands that have
Nonstandard Clauses subsections.
Perhaps something more sophisticated can be built by using dedicated XML
tags in an ad-hoc namespace.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-02-14 16:50 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-02-14 16:05 documenting divergence from the SQL spec Dave Cramer <davecramer@postgres.rocks>
2020-02-14 16:26 ` Tom Lane <tgl@sss.pgh.pa.us>
2020-02-14 16:43 ` Dave Cramer <davecramer@postgres.rocks>
2020-02-14 16:50 ` Alvaro Herrera <alvherre@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox