Sample Header Ad - 728x90

Use of integer instead of interval (of one type)

3 votes
1 answer
1266 views
Our DB design presently has a interval column which will only be storing days (no other interval type) so it is making sense to use INT2 (smallint) instead of interval. Reference to documentation. Advantage: 2 bytes instead of 12 bytes (we have many such columns). Is this line of thinking ok or am I overlooking something?
Asked by vedic (180 rep)
Mar 8, 2014, 07:28 AM
Last activity: Feb 3, 2023, 05:17 PM