km(at)acrasis(dot)net wrote:
> Would I be right in thinking that, in general, a column to hold
> timestamp values is best created with type 'TIMESTAMP WITH TIME ZONE'
> and not 'TIMESTAMP' nor 'TIMESTAMP WITHOUT TIME ZONE'?
>
> To put it another way, for what reasons might the 'TIMESTAMP' type be
> preferred to 'TIMESTAMP WITH TIME ZONE'?
>
We use the database to store one minute roll up stats from our main
application. Each of these has a timestamp on it.
There's really no need for timestamptz in this instance.