From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
Cc: | Joshua Moore-Oliva <josh(at)chatgris(dot)com>, Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: now() AT TIME ZONE interval '-5 hours' returns type interval??? |
Date: | 2003-03-14 16:59:07 |
Message-ID: | 21821.1047661147@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Steve Crawford <scrawford(at)pinpointresearch(dot)com> writes:
> On Thursday 13 March 2003 8:10 pm, Tom Lane wrote:
>> UPDATE pg_proc SET prorettype = 1114 WHERE prosrc = 'timestamptz_izone';
> This syntax looked useful to me so I tried the update you suggested
> (fortunately on an old test system running 7.2.3) and now it only returns
> 2000-01-01 00:00:00. Always.
Sorry, I should have made it clear that that patch was only for 7.3.*.
7.2 has a much more primitive AT TIME ZONE facility --- IIRC, the
function in question returns TEXT in 7.2. (The origin of this problem
seems to be that Tom Lockhart left before he'd finished debugging his
latest round of date-and-time improvements.)
If you need to fix your test system, change the value back to 25.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-14 17:04:55 | Re: Automake |
Previous Message | Alvaro Herrera | 2003-03-14 16:49:37 | Re: Online docs down again |