Skip site navigation (1) Skip section navigation (2)

data storage for timestamp data type?

From: Chirag Patel <patelc75(at)yahoo(dot)com>
To: PostgreSQL Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: data storage for timestamp data type?
Date: 2007-08-14 18:52:47
Message-ID: 808018.20783.qm@web52810.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
The timestamp data type in postgreSQL has the option for a parameter 'p' that defines the precision from 0-6. The documentation indicates 8 bytes as the default size for the column.

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

Thanks!
Chirag

PS. By the way, I think clustering question hit the list 3 times by accident last week. I apologize, I used the wrong e-mail address and assumed the first 2 didn't make it.

Responses

pgsql-novice by date

Next:From: Michael GlaesemannDate: 2007-08-14 19:16:26
Subject: Re: data storage for timestamp data type?
Previous:From: Steve CrawfordDate: 2007-08-14 18:23:13
Subject: Re: Postmaster start up problems (can't create lock file )

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group