BUG #4090: ECPG Selecting table with NULL values

From: "Mikael Omma" <mikael(dot)omma(at)ge(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4090: ECPG Selecting table with NULL values
Date: 2008-04-04 12:32:44
Message-ID: 200804041232.m34CWiI3004947@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4090
Logged by: Mikael Omma
Email address: mikael(dot)omma(at)ge(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mikael Omma 2008-04-04 12:38:22 BUG #4091: ECPG $select incompability with Informix
Previous Message Ceschia, Marcello 2008-04-04 07:20:16 Re: [PATCHES] Re: BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data