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

Precision of time types

From: Wolfgang Keller <wolfgang(dot)keller(dot)privat(at)gmx(dot)de>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Precision of time types
Date: 2007-11-13 11:45:39
Message-ID: 988223449A3F5A0D4A67CE35@[] (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

and yet another clueless newbie question:

The precision of time types is specified as follows in the 

"For the time types, the allowed range of p is from 0 to 6 when 
eight-byte integer storage is used, or from 0 to 10 when floating-point 
storage is used."

When/how is the internal storage method determined?

Compile-time option?
Database-initialisation time option?

Unfortunately, the schema I am trying to implement using PostgreSQL 
specifies 9 digits (nanosecond precision) for its custom datetime 
column (don't ask me why, I'M just a poor mech eng).

So, do I need to use a numeric type for the seconds and define my own 
composite datetime column or can I use a properly parameterized 
built-in time type of PostgreSQL?



Wolfgang Keller


pgsql-novice by date

Next:From: gokulDate: 2007-11-13 16:52:34
Subject: Re: postgresql 8.1.10-1PGDG (32 bit) installaion on RHEL4
Previous:From: Wolfgang KellerDate: 2007-11-13 11:32:04
Subject: Composite types for composite primary/foreign keys?

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