Re: best type for unix file system timestamp?
От | Robby Russell |
---|---|
Тема | Re: best type for unix file system timestamp? |
Дата | |
Msg-id | 1091231521.2575.98.camel@vacant обсуждение исходный текст |
Ответ на | Re: best type for unix file system timestamp? ("Glen Parker" <glenebob@nwlink.com>) |
Ответы |
Re: best type for unix file system timestamp?
|
Список | pgsql-general |
Exactly, with using 'timestamp' you gain data integrity as the database will make sure that it only accepts valid timestamps. So, if your code that you use to INSERT gets skewed someway, it will fail if you try to insert an invalid number. -Robby On Fri, 2004-07-30 at 14:26, Glen Parker wrote: > 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)? > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- Robby Russell | Owner.Developer.Geek PLANET ARGON | www.planetargon.com Portland, OR | robby@planetargon.com 503.351.4730 | blog.planetargon.com
В списке pgsql-general по дате отправления: