Re: best type for unix file system timestamp? - Mailing list pgsql-general

From Glen Parker
Subject Re: best type for unix file system timestamp?
Date
Msg-id AJEKKAIECKNMBCEKADJPAEBKCLAA.glenebob@nwlink.com
Whole thread Raw
In response to best type for unix file system timestamp?  (Mark Harrison <mh@pixar.com>)
Responses Re: best type for unix file system timestamp?
List 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)?


pgsql-general by date:

Previous
From: Mark Harrison
Date:
Subject: best type for unix file system timestamp?
Next
From: Si Chen
Date:
Subject: pg_hba.conf changes without restarting postmaster