Re: text coverage for EXTRACT() - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: text coverage for EXTRACT()
Date
Msg-id dd0d6a59-acc9-a585-fecf-1bd8f3466ec0@postgresfriends.org
Whole thread Raw
In response to text coverage for EXTRACT()  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: text coverage for EXTRACT()
List pgsql-hackers
On 6/9/20 1:36 PM, Peter Eisentraut wrote:
> During the discussion in [0] I noticed that the extract()/date_part()
> variants for time, timetz, and interval had virtually no test coverage.
> So I put some more tests together, which should be useful if we decide
> to make any changes in this area per [0].


These look straightforward to me.

Looking at that big table, I see everything is 0-based except the
quarter.  That seems unfortunate, and if this were a new feature I'd
lobby to have it changed.  I don't think we can do anything about it
now, though.
-- 
Vik Fearing



pgsql-hackers by date:

Previous
From: Georgios
Date:
Subject: Re: Include access method in listTables output
Next
From: Amit Kapila
Date:
Subject: Re: Bump default wal_level to logical