pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedBetter example
5+ messages / 4 participants
[nested] [flat]
* Better example
@ 2016-11-08 18:01 dfm@ringing.org
0 siblings, 1 reply; 5+ messages in thread
From: dfm@ringing.org @ 2016-11-08 18:01 UTC (permalink / raw)
To: pgsql-docs
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/datatype-numeric.html
Description:
I think that in the section on floating point Infinity/-Infinity/NaN in the
Data Types chapter the example would be better setting it to -Infinity
rather than positive, as that would make clear that the minus sign needs to
be within the quote marks. This isn't clear otherwise.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Better example
@ 2016-11-23 17:59 Bruce Momjian <bruce@momjian.us>
parent: dfm@ringing.org
0 siblings, 2 replies; 5+ messages in thread
From: Bruce Momjian @ 2016-11-23 17:59 UTC (permalink / raw)
To: dfm@ringing.org; +Cc: pgsql-docs
On Tue, Nov 8, 2016 at 06:01:58PM +0000, dfm@ringing.org wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.5/static/datatype-numeric.html
> Description:
>
> I think that in the section on floating point Infinity/-Infinity/NaN in the
> Data Types chapter the example would be better setting it to -Infinity
> rather than positive, as that would make clear that the minus sign needs to
> be within the quote marks. This isn't clear otherwise.
Is the attached patch what you are suggesting?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
infinity.diff (text/x-diff, 1016B) download
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
new file mode 100644
index 67d0c34..fbc3576
*** a/doc/src/sgml/datatype.sgml
--- b/doc/src/sgml/datatype.sgml
*************** FROM generate_series(-3.5, 3.5, 1) as x;
*** 750,756 ****
floating-point arithmetic does not follow IEEE 754, these values
will probably not work as expected.) When writing these values
as constants in an SQL command, you must put quotes around them,
! for example <literal>UPDATE table SET x = 'Infinity'</>. On input,
these strings are recognized in a case-insensitive manner.
</para>
--- 750,756 ----
floating-point arithmetic does not follow IEEE 754, these values
will probably not work as expected.) When writing these values
as constants in an SQL command, you must put quotes around them,
! for example <literal>UPDATE table SET x = '-Infinity'</>. On input,
these strings are recognized in a case-insensitive manner.
</para>
* Re: Better example
@ 2016-11-23 18:40 Don Morrison <dfm@ringing.org>
parent: Bruce Momjian <bruce@momjian.us>
1 sibling, 0 replies; 5+ messages in thread
From: Don Morrison @ 2016-11-23 18:40 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-docs
On Wed, Nov 23, 2016 at 12:59 PM, Bruce Momjian <bruce@momjian.us> wrote:
> Is the attached patch what you are suggesting?
Yup, b is what I had in mind.
Thanks!
--
Don Morrison <dfm@ringing.org>
"Nobody minds having what is too good for them."
-- Jane Austen, _Mansfield Park_
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Better example
@ 2017-03-21 02:22 Bruce Momjian <bruce@momjian.us>
parent: Bruce Momjian <bruce@momjian.us>
1 sibling, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2017-03-21 02:22 UTC (permalink / raw)
To: dfm@ringing.org; +Cc: pgsql-docs
On Wed, Nov 23, 2016 at 12:59:41PM -0500, Bruce Momjian wrote:
> On Tue, Nov 8, 2016 at 06:01:58PM +0000, dfm@ringing.org wrote:
> > The following documentation comment has been logged on the website:
> >
> > Page: https://www.postgresql.org/docs/9.5/static/datatype-numeric.html
> > Description:
> >
> > I think that in the section on floating point Infinity/-Infinity/NaN in the
> > Data Types chapter the example would be better setting it to -Infinity
> > rather than positive, as that would make clear that the minus sign needs to
> > be within the quote marks. This isn't clear otherwise.
>
> Is the attached patch what you are suggesting?
Patch applied.
---------------------------------------------------------------------------
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + As you are, so once was I. As I am, so you will be. +
> + Ancient Roman grave inscription +
> diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
> new file mode 100644
> index 67d0c34..fbc3576
> *** a/doc/src/sgml/datatype.sgml
> --- b/doc/src/sgml/datatype.sgml
> *************** FROM generate_series(-3.5, 3.5, 1) as x;
> *** 750,756 ****
> floating-point arithmetic does not follow IEEE 754, these values
> will probably not work as expected.) When writing these values
> as constants in an SQL command, you must put quotes around them,
> ! for example <literal>UPDATE table SET x = 'Infinity'</>. On input,
> these strings are recognized in a case-insensitive manner.
> </para>
>
> --- 750,756 ----
> floating-point arithmetic does not follow IEEE 754, these values
> will probably not work as expected.) When writing these values
> as constants in an SQL command, you must put quotes around them,
> ! for example <literal>UPDATE table SET x = '-Infinity'</>. On input,
> these strings are recognized in a case-insensitive manner.
> </para>
>
>
> --
> Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-docs
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 5+ messages in thread
* Better Example
@ 2019-08-12 08:17 PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 5+ messages in thread
From: PG Doc comments form @ 2019-08-12 08:17 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: saharsh.pruthi@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/functions-json.html
Description:
In Table 9-41, for 4th row(?|)
'{"a":1, "b":2}'::jsonb ?| array['b', 'c']
would be a better example to illustrate the operation of ?| than
'{"a":1, "b":2, "c":3}'::jsonb ?| array['b', 'c']
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-08-12 08:17 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-11-08 18:01 Better example dfm@ringing.org
2016-11-23 17:59 ` Bruce Momjian <bruce@momjian.us>
2016-11-23 18:40 ` Don Morrison <dfm@ringing.org>
2017-03-21 02:22 ` Bruce Momjian <bruce@momjian.us>
2019-08-12 08:17 Better Example PG Doc comments form <noreply@postgresql.org>
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