Re: best type for unix file system timestamp?

From: "Glen Parker" <glenebob(at)nwlink(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: best type for unix file system timestamp?
Date: 2004-07-30 21:26:08
Message-ID: AJEKKAIECKNMBCEKADJPAEBKCLAA.glenebob@nwlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

However it may be represented, it IS a timestamp, so why not use a timestamp
data type if you have one available to you? That's what data types are for
after all...

> So, I'm recording the timestamp from some unix files.
>
> Any opinions as to whether it's best to use a "bigint"
> (which matches the file system data) or a "timestamp"
> (which might be easier to manipulate in the database)?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Si Chen 2004-07-30 22:51:42 pg_hba.conf changes without restarting postmaster
Previous Message Mark Harrison 2004-07-30 21:08:08 best type for unix file system timestamp?