"nagash" <[EMAIL PROTECTED]> writes:
> site_utf=# SELECT to_char(NOW() - '2000-10-02'::date, 'YYYYMonDD');
> server closed the connection unexpectedly
Hmm, I get bad output rather than a core dump, but it certainly seems
like a "must fix" if a dump is possible. Karel, can you look into it?
regression=# select to_char('1605 days 12:09:35'::interval, 'YYYYMonDD');
to_char
-----------
[EMAIL PROTECTED]
(1 row)
regression=#
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match