"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