On Thu, Nov 10, 2005 at 06:01:22PM +0100, juleni@xxxxxxxxxxxx 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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
