Re: data storage for timestamp data type? - Mailing list pgsql-novice

From Michael Glaesemann
Subject Re: data storage for timestamp data type?
Date
Msg-id FF6C5089-51FA-4869-B6F8-1E558517315F@seespotcode.net
Whole thread Raw
In response to data storage for timestamp data type?  (Chirag Patel <patelc75@yahoo.com>)
List pgsql-novice
On Aug 14, 2007, at 13:52 , Chirag Patel wrote:

> If I use timestamp(3) as an example, will postgres still allocate
> the entire 8 bytes for the column or reduce it?

8 bytes will still be allocated. Internally it's an 8-byte int or an
8-byte float depending on whether or not you compiled with enable-
integer-datetimes.

Michael Glaesemann
grzm seespotcode net



pgsql-novice by date:

Previous
From: Chirag Patel
Date:
Subject: data storage for timestamp data type?
Next
From: Michael Glaesemann
Date:
Subject: Re: data storage for timestamp data type?