| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Dirk Heinrichs <dirk(dot)heinrichs(at)altum(dot)de> |
| 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 20:37:12 |
| Message-ID: | 458.1288903032@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Dirk Heinrichs <dirk(dot)heinrichs(at)altum(dot)de> writes:
> 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.
Committed with minor cleanup.
> BTW: Is there a way to achieve the same in pure PL/pgSQL or PL/perl?
plpgsql doesn't have any facility for working with run-time-determined
column names. I think it wouldn't be too hard in plperl though.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henry C. | 2010-11-05 09:54:45 | Re: BUG #5736: 9.0.1 segmentation fault (sig11) during long-lived update |
| Previous Message | Dirk Heinrichs | 2010-11-04 18:40:53 | Re: BUG #5740: contrib/spi/moddatetime.c doesn't work with timezones. |