Re: Storing a time interval - Mailing list pgsql-general

From Michael Lewis
Subject Re: Storing a time interval
Date
Msg-id CAHOFxGp8C=F2v0zLurSWMXaSkKzTXbN7ZbeNHmAR4vXWu7ciGg@mail.gmail.com
Whole thread Raw
In response to Re: Storing a time interval  (stan <stanb@panix.com>)
Responses Re: Storing a time interval
List pgsql-general
CREATE TYPE po_dates AS (
    po_isssued_date        timestamptz,
        discount_last_date     timestamptz,
        net_date               timestamptz
        );

What advantage does combining these three values into a custom composite type give you rather than just storing directly? Are you going to reuse this po_dates type on many tables?

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: firewall trouble on Windows
Next
From: Steve Baldwin
Date:
Subject: Re: Storing a time interval