Some slight clarifications...
> > I would like to know how to create a timestamp value without time zone.
> There is a data type without time zone. It's just called
> 'timestamp'
This is mostly true for the upcoming version 7.2, but is not the case
for older versions (it could be, and probably should be, but isn't ;).
Here are some details on the differences, and how those differences are
going away:
o timestamp with/without time zone all map to the same "timezone aware"
data type in versions prior to 7.2.
o For 7.2, "timestamp" maps to "timestamp with time zone" to help with
upgrading from 7.1 and before. For 7.3, it is likely that we will
conform more closely to the SQL9x standard and have it map to "timestamp
without time zone". But imho y'all should be using timezones in most
cases anyway. You can get "timestamp without time zone" by specifying it
explicitly.
o In any version, you can control which time zone is used by your
application. So if you don't want it shifting around to reflect local
reality, then you can force it to a specific offset or to zero. Things
will behave pretty much like a "zoneless" data type.
hth
- Thomas