While debugging with valgrind, I always receive the following error
message.
==30439== Invalid free() / delete / delete[]
==30439==at 0x400448F9: free (vg_clientfuncs.c:180)
==30439==by 0x421136CD: (within /lib/i686/libc-2.2.5.so)
==30439==by 0x4207F852: (within /lib/i686/libc-2.2.5.
When selecting with the AT TIME ZONE or timezone function, the returned value
is not always a timestamp. This is inconsistent with the documentation.
To reproduce this problem, run these two queries.
SELECT now() AT TIME ZONE 'EST'
returns 2003-03-13 21:27:14.63401-05
SELECT now() AT TIME ZONE
In addition, I have upgraded to postgre 7.3.2 instead of postgre 7.3 and I get
the exact same output except that years are included in the interval.
It still returns an interval instead of a timestamp.
josh.
On March 13, 2003 10:12 pm, Joshua Moore-Oliva wrote:
> When selecting with the
e by doing
UPDATE pg_proc SET prorettype = 1114 WHERE prosrc = 'timestamptz_izone';"
This fixed the problem for me.
Josh.
On March 13, 2003 10:12 pm, Joshua Moore-Oliva wrote:
> When selecting with the AT TIME ZONE or timezone function, the returned
> value is not always a timest
When selecting with the AT TIME ZONE or timezone function, the returned value
is not always a timestamp. This is inconsistent with the documentation.
To reproduce this problem, run these two queries.
SELECT now() AT TIME ZONE 'EST'
returns 2003-03-13 21:27:14.63401-05
SELECT now() AT TIME ZON
