Re: [GENERAL] timestamp(0) vs. timestamp

2011-04-28 Thread Erwin Brandstetter
On 27.04.2011 19:36, Tom Lane wrote: Erwin Brandstetter writes: Hi all! This may seem unimportant, but I still would like to know. I have columns for timestamps without fractional digits, so I could define them as timestamp(0). However, there is no way fractions could ever enter anyway, because

Re: [GENERAL] timestamp(0) vs. timestamp

2011-04-27 Thread Tom Lane
Erwin Brandstetter writes: > Hi all! > This may seem unimportant, but I still would like to know. > I have columns for timestamps without fractional digits, so I could > define them as timestamp(0). > However, there is no way fractions could ever enter anyway, because > triggers and / or checks g

[GENERAL] timestamp(0) vs. timestamp

2011-04-27 Thread Erwin Brandstetter
Hi all! This may seem unimportant, but I still would like to know. I have columns for timestamps without fractional digits, so I could define them as timestamp(0). However, there is no way fractions could ever enter anyway, because triggers and / or checks guarantee values without fractional seco