Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.

From: Dirk Heinrichs <dirk(dot)heinrichs(at)altum(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.
Date: 2010-11-04 18:40:53
Message-ID: 4CD2FE35.50702@altum.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Am 04.11.2010 04:55, schrieb Tom Lane:

> I don't actually see any point in having two functions at all. Since
> the trigger is examining the column type internally, it could perfectly
> well do the right thing at runtime depending on column type.

Got the point. Here's another patch, hope my limited C skills are
sufficient... Works here, at least.

BTW: Is there a way to achieve the same in pure PL/pgSQL or PL/perl?

Bye...

Dirk

Attachment Content-Type Size
moddatetime.patch text/x-diff 2.1 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-11-04 20:37:12 Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.
Previous Message Tom Lane 2010-11-04 16:56:20 Re: [PERFORM] typoed column name, but postgres didn't grump