More on previous bug report

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-bugs(at)postgresql(dot)org
Subject: More on previous bug report
Date: 2000-12-14 06:04:46
Message-ID: 20001214000446.A1001@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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;

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2000-12-14 06:29:01 Duplicate records leaking into unique indexed tables
Previous Message Bruno Wolff III 2000-12-14 04:49:23 Bug report