Re:Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate

From: "yanliang lei" <msdnchina(at)163(dot)com>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re:Re: BUG #18034: Accept the spelling "+infinity" in datetime input is not accurate
Date: 2023-08-18 13:57:17
Message-ID: 3f714db4.6b78.18a08efa2fd.Coremail.msdnchina@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dear everyone,
I raise this question based on the following considerations:
1. Make PostgreSQL easier for beginners to learn;
2. PostgreSQL is a database software product rather than a database software project. A product means being more user-friendly, precise, and reducing the likelihood of misunderstandings。

The datetime type may make beginners think that there is a datetime data type in the PostgreSQL database. Although senior PostgreSQL professionals know that there is no datetime data type, the datetime type is enough to make beginners misunderstand.
However, When they saw that the ReleaseNote in PostgreSQL 16 recorded "Accept the spelling"+infinity "in datetime type input",
the term 'datetime type' is sufficient for beginners to misunderstand , unless it is noted that 'datetime type' is a general term, representing the following PostgreSQL data types: timestamp [(p)] [without time zone], timestamp [(p)] with time zone, date。

I am not nitpicking ,I hope that: PostgreSQL database software products can become more perfect and accurate。
Thanks a lot!

At 2023-08-10 19:25:51, "Bruce Momjian" <bruce(at)momjian(dot)us> wrote:
>On Wed, Aug 9, 2023 at 10:53:27PM -0400, Tom Lane wrote:
>> Bruce Momjian <bruce(at)momjian(dot)us> writes:
>> > We call our timestamp type datetime in some cases, e.g.:
>> > ...
>> > I see it in a few other places. Should we rename it other places too?
>> > I thought datetime was just a short-hand for our date-time types.
>>
>> I don't see much reason to change anything here. "Datetime" is not
>> a perfectly strict classification, eg it might or might not include
>> "interval" depending on context, and I don't want to try to make
>> that exact.
>>
>> A more specific release note entry could be "Accept the spelling
>> '+infinity' for datetime types that accept infinity"; but I'm not
>> sure it's worth the extra verbiage.
>
>Yeah, that was my analysis too.
>
>--
> Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
> EDB https://enterprisedb.com
>
> Only you can decide what is important to you.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2023-08-18 14:28:36 BUG #18061: The psql -v variable option does not work for the -c command option
Previous Message PG Bug reporting form 2023-08-18 09:30:51 BUG #18060: Left joining rows using random() function in join condition doesn't work as expected.