Storing a time interval - Mailing list pgsql-general

From stan
Subject Storing a time interval
Date
Msg-id 20191108194307.GA16920@panix.com
Whole thread Raw
Responses Re: Storing a time interval
List pgsql-general
I need to create a table to store terms and conditions for purchase
orders.

Some of the attributes of a PO include payment terms. Quite often these will
be 2 periods associated with these, the first is a period on which if you
pay, you receive a discount, and the 2nd is when payment is due with no
discount. I am thinking of storing these two attributes as time internals.

What is the wisdom as to how to declare the type of these columns?


-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin



pgsql-general by date:

Previous
From: "Brad Nicholson"
Date:
Subject: Re: AW: AW: AW: AW: AW: AW: AW: broken backup trail in case of quicklypatroni switchback and forth
Next
From: Olivier Gautherot
Date:
Subject: pg_logical for RHEL 8