More on previous bug report
Bruno Wolff III <bruno@wolff.to>
From: Bruno Wolff III <bruno@wolff.to>
To: pgsql-bugs@postgresql.org
Date: 2000-12-14T06:04:46Z
Lists: pgsql-bugs
I think the problem is somehow related to roman numeral conversion when some values are null. The following seems to work: select case when gen is not null then to_char(gen,'rn') else null end, case when gen is not null then to_char(gen+1,'rn') else null end from cname; While the following doesn't: select to_char(gen,'rn'), to_char(gen+1,'rn') cname;