Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones. - Mailing list pgsql-bugs

From Dirk Heinrichs
Subject Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.
Date
Msg-id 4CD2FE35.50702@altum.de
Whole thread Raw
In response to Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORM] typoed column name, but postgres didn't grump
Next
From: Tom Lane
Date:
Subject: Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones.