Re: (8.1) to_timestamp correction (epoch to timestamptz)

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-patches Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: (8.1) to_timestamp correction (epoch to timestamptz)
Date: 2005-06-12 11:38:00
Message-ID: C9B76C86-BAD5-4028-A290-0E205F7E953A@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


On Jun 10, 2005, at 1:29 AM, Bruce Momjian wrote:

> I have modified your original patch and applied it. Tom mentioned
> to me
> privately that none of the AT TIME ZONE clauses is required, probably
> because epoch is already UTC, and adding seconds to it just keeps it
> UTC, then it is converted to your local timezone for display. I also
> found your patch was lacking two _null_ columns that are now needed
> because of pg_proc column additions.

Thank, Tom and Bruce, for fixing and applying my patch.

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Michael Glaesemann 2005-06-12 13:41:47 --enable-integer-datetimes doc patch
Previous Message Neil Conway 2005-06-12 00:11:46 Re: PQmakeEmptyPGresult() will return NULL if allocation