Re: text coverage for EXTRACT()

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: text coverage for EXTRACT()
Date: 2020-06-09 13:02:45
Message-ID: dd0d6a59-acc9-a585-fecf-1bd8f3466ec0@postgresfriends.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2020-06-09 13:05:39 Re: Bump default wal_level to logical
Previous Message Georgios 2020-06-09 12:19:31 Re: Include access method in listTables output