On Thu, Nov 10, 2005 at 06:01:22PM +0100, juleni(at)livetrade(dot)cz wrote:
> Thanks for answer, I will use TIMESTAMP WITH TIMEZONE.
The only thing I would add is you don't seem to be able to
index a part of the timestamp with time zone value. As an
example, I had a table with around 10m rows where I wanted
to query by date. In order to add an index liki
date_part(mytimestamp), you need to use timestamp without
time zone.
S
--
http://www.cm.nu/~shane/