Re: Storing a time interval

Поиск
Список
Период
Сортировка
От Steve Baldwin
Тема Re: Storing a time interval
Дата
Msg-id CAKE1Aib_+NhhD69Pdej-YOCuetq5NeKYAGc67z-Pruu24AZTmw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Storing a time interval  (Michael Lewis <mlewis@entrata.com>)
Ответы Re: Storing a time interval
Список pgsql-general
I agree with Michael. Another consideration is how the composite type is going to be handled in the DB layer of your processing code (e.g. node, python, ...).  In the scenario you described it seems unlikely you will be either having multiple columns of that type on your PO table, or using that composite type on a different table, so apart from the 'interest' factor, I'm not seeing any practical benefit.  Composite types are also slightly painful in the change they bring to the way you reference them. For example typically you need to surround the outer column in brackets - e.g. (dates).discount_last_date. If you are using an ORM library, does it know how to deal with that?

Steve

On Sat, Nov 9, 2019 at 8:11 AM Michael Lewis <mlewis@entrata.com> wrote:
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 по дате отправления:

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Storing a time interval
Следующее
От: Israel Brewster
Дата:
Сообщение: Merge sort/postgis performance tweaking?