From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Strauss, Randy (ARC-AF)[SGT, INC] <randolph.a.strauss@nasa.gov>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: Lack of detailed documentation
Date: Mon, 10 Feb 2020 15:43:40 -0500
Message-ID: <27125.1581367420@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwYd-G4o0a79pP8TuCvSYB-4B8ddSvADiEg3MVbKr_iRuA@mail.gmail.com>
References: <158110996889.1089.4224139874633222837@wrigleys.postgresql.org>
<CAKFQuwaUAxHPRn8t0zUA+ctE0dKDYhESGg2rnRJB8r8gN_XgfA@mail.gmail.com>
<6537.1581264535@sss.pgh.pa.us>
<3D8A56AB-AC13-46D7-B72B-B913A4ACDA7D@nasa.gov>
<CAKFQuwYd-G4o0a79pP8TuCvSYB-4B8ddSvADiEg3MVbKr_iRuA@mail.gmail.com>
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> I doubt anyone disagrees with the sentiment but the last time the lack of
> documentation was brought up here was years ago and no one stepped up then
> to volunteer their time to improve this lesser used area of the database
> and it doesn't seem likely to happen organically here either as this
> message seems to imply a lack of interest in being part of the solution.
Yeah. Attached is my proposal for clarifying what to do to rotate.
There's a lot more that could be done to improve this page --- for
one thing, most of the other similar tables show the results of the
examples, and for another, it's pretty unclear which data types
each operator takes. But I don't have the time or interest to
tackle a major rewrite, and so far nobody else has stepped up either.
One thing that's sort of blocking any real progress on this is the
draconian space constraints imposed by the tabular format, which is
hurting us on a lot of these pages, not just this one. Alvaro did
some preliminary investigation towards finding a better way [1],
but nobody's tried to push that forward.
regards, tom lane
[1] https://www.postgresql.org/message-id/20200116184444.GA25792%40alvherre.pgsqlAttachments:
[text/x-diff] better-geometry-rotation-examples.patch (1.1K, ../27125.1581367420@sss.pgh.pa.us/2-better-geometry-rotation-examples.patch)
download | inline diff:diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgmlindex ceda48e..400b21d 100644--- a/doc/src/sgml/func.sgml+++ b/doc/src/sgml/func.sgml@@ -8363,12 +8363,18 @@ CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple
<row>
<entry> <literal>*</literal> </entry>
<entry>Scaling/rotation</entry>
- <entry><literal>box '((0,0),(1,1))' * point '(2.0,0)'</literal></entry>+ <entry>+ <para><literal>path '(0,0),(1,0),(1,1)' * point '(3.0,0)'</literal></para>+ <para><literal>path '(0,0),(1,0),(1,1)' * point(cosd(45), sind(45))</literal></para>+ </entry>
</row>
<row>
<entry> <literal>/</literal> </entry>
<entry>Scaling/rotation</entry>
- <entry><literal>box '((0,0),(2,2))' / point '(2.0,0)'</literal></entry>+ <entry>+ <para><literal>path '(0,0),(1,0),(1,1)' / point '(2.0,0)'</literal></para>+ <para><literal>path '(0,0),(1,0),(1,1)' / point(cosd(45), sind(45))</literal></para>+ </entry>
</row>
<row>
<entry> <literal>#</literal> </entry>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, randolph.a.strauss@nasa.gov, pgsql-docs@lists.postgresql.org
Subject: Re: Lack of detailed documentation
In-Reply-To: <27125.1581367420@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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