Message-ID: <63bed955-3353-5b1d-4855-2152c3cdf01e@postgresfriends.org>
Date: Sat, 19 Aug 2023 21:39:12 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.13.0
Subject: Re: BUG #18034: Accept the spelling "+infinity" in datetime input is
 not accurate
Content-Language: en-US
To: yanliang lei <msdnchina@163.com>, Bruce Momjian <bruce@momjian.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@lists.postgresql.org
References: <18034-08e668401be826ed@postgresql.org>
 <ZNRN1aF0Ls2SbleN@momjian.us> <26522.1691636007@sss.pgh.pa.us>
 <ZNTJP9Y6fIoJCJ8f@momjian.us>
 <3f714db4.6b78.18a08efa2fd.Coremail.msdnchina@163.com>
From: Vik Fearing <vik@postgresfriends.org>
In-Reply-To: <3f714db4.6b78.18a08efa2fd.Coremail.msdnchina@163.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/63bed955-3353-5b1d-4855-2152c3cdf01e%40postgresfriends.org>
Precedence: bulk

On 8/18/23 15:57, yanliang lei wrote:
> 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！

On the other hand, the standard talks about datetime types as a 
collection of dates, times, timestamps, and intervals; and there is no 
type called "datetime" in the standard.  We are just doing the same 
thing here.
-- 
Vik Fearing