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

From Pankaj Jangid
Subject Re: Storing a time interval
Date
Msg-id m28sopqy5h.fsf@gmail.com
Whole thread Raw
In response to Re: Storing a time interval  (Steve Baldwin <steve.baldwin@gmail.com>)
List pgsql-general
Steve Baldwin <steve.baldwin@gmail.com> writes:
> 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?
>

I faced a similar issue when using Enums with with rust lang. The Diesel
ORM didn't support it directly. Had to struggle with custom code in the
Model layer.

-- 
Pankaj Jangid



pgsql-general by date:

Previous
From: Israel Brewster
Date:
Subject: Merge sort/postgis performance tweaking?
Next
From: Peter Eisentraut
Date:
Subject: Re: logical replication - negative bitmapset member not allowed