Tom Lane escribió: > Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > > You can't do this because to_date and other functions are not immutable. > > 8.2 seems to be more picky about this -- the date conversions of > > timestamptz columns are dependent on the current timezone. > > The reason 8.2 is more picky is that the function is less immutable > thanks to the addition of locale-dependent functionality: > http://archives.postgresql.org/pgsql-committers/2006-11/msg00264.php Ah. It was a good try in any case I think :-P The reason I confused the issue is that I had been fiddling with date_trunc on a timestamptz column and found that it didn't really work as I expected. (I can't recall exactly ATM but I think it was 8.1 anyway). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
