Re: text coverage for EXTRACT()

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