The following bug has been logged online:
Bug reference: 4090
Logged by: Mikael Omma
Email address: mikael.omma@ge.com
PostgreSQL version: 8.2.6
Operating system: SUSE Linux 10
Description: ECPG Selecting table with NULL values
Details:
In ECPG when I have "$select a into :a from table where b = :b;" this query
raises an error if the value a is NULL.
If I have added the indicator value "$select a int :a, :a_ind from table
where b = :b;" this also raises the same error. I cannot read rows including
null values without raising this error. From the documentation the
indicator value should prevent raising this error but it is not.
I compile with INFORMIX compablity mode from ESQL sourcecode ported to
PostgreSQL.