More on previous bug report - Mailing list pgsql-bugs

From Bruno Wolff III
Subject More on previous bug report
Date
Msg-id 20001214000446.A1001@wolff.to
Whole thread Raw
List 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;

pgsql-bugs by date:

Previous
From: Gena Gurchonok
Date:
Subject: Windows ODBC tables list (with 7.1 CVS)
Next
From: Kovacs Zoltan Sandor
Date:
Subject: to_char() causes backend to close connection