Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group