On Thu, 20 Oct 2022 at 22:12, Tom Lane <t...@sss.pgh.pa.us> wrote: > Japin Li <japi...@hotmail.com> writes: >> On Thu, 20 Oct 2022 at 20:45, Erik Rijkers <e...@xs4all.nl> wrote: >>> I noticed that >>> select date_part('millennium', now()); --> 3 >>> >>> will execute also, unperturbed, in this form: >>> select date_part('millennium xxxxx', now()); --> 3 > >> Maybe we should document this. I'd be inclined to change the code to >> match the certain valid field names. > > I think changing this behavior has a significant chance of drawing > complaints and zero chance of making anyone happier. >
Maybe. > The current state of affairs (including the lack of unnecessary > documentation detail) is likely quite intentional. > I'm curious about why not document this? -- Regrads, Japin Li. ChengDu WenWu Information Technology Co.,Ltd.