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?
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?
pgsql-novice by date
|Next:||From: gokul||Date: 2007-11-13 16:52:34|
|Subject: Re: postgresql 8.1.10-1PGDG (32 bit) installaion on RHEL4|
|Previous:||From: Wolfgang Keller||Date: 2007-11-13 11:32:04|
|Subject: Composite types for composite primary/foreign keys?|