Re: Storing a time interval

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: stan <stanb(at)panix(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Storing a time interval
Date: 2019-11-08 21:10:36
Message-ID: CAHOFxGp8C=F2v0zLurSWMXaSkKzTXbN7ZbeNHmAR4vXWu7ciGg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Baldwin 2019-11-08 21:20:26 Re: Storing a time interval
Previous Message Adrian Klaver 2019-11-08 20:50:10 Re: firewall trouble on Windows