Bruce Momjian writes:
> The thing I don't like about 00:00:00 is that it is a lot of information
> to say "the start of the day", while I assumed midnight was clear on
> that. If we can find a way to say "start of the day (midnight)", that
> would work.
One really simple way to make it shorter
On Wed, Jul 10, 2019 at 01:32:31PM -0400, Jonathan Katz wrote:
> On 7/10/19 6:13 AM, David Harper wrote:
> >> I actually agree with your opinion that "midnight" is fine.
> >> That text has been that way for over fifteen years[1], and
> >> nobody's complained before that it was ambiguous.
> >
> > C
On 7/10/19 6:13 AM, David Harper wrote:
>> I actually agree with your opinion that "midnight" is fine.
>> That text has been that way for over fifteen years[1], and
>> nobody's complained before that it was ambiguous.
>
> Conversely, how many users over the past fifteen years have read that table,
> I actually agree with your opinion that "midnight" is fine.
> That text has been that way for over fifteen years[1], and
> nobody's complained before that it was ambiguous.
Conversely, how many users over the past fifteen years have read that table,
and then felt compelled (as I did) to run a q
On Tue, Jul 09, 2019 at 06:59:59PM -0400, Tom Lane wrote:
> Alvaro Herrera writes:
>>
>>
>>Unique constraints on partitioned tables (as well as primary keys)
>>must constrain all the partition key columns. This limitation exists
>>because PostgreSQL can only e