Re: BUG #4090: ECPG Selecting table with NULL values

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Mikael Omma <mikael(dot)omma(at)ge(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4090: ECPG Selecting table with NULL values
Date: 2008-04-06 14:29:05
Message-ID: 20080406142905.GA26661@feivel.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 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.

Could you send us a test case? Does it work when not using INFORMIX
mode? Do you use the "-r no_indicator" option?

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-04-06 15:16:54 Re: BUG #4095: Out of memory when restore db
Previous Message Pavel Zaitsev 2008-04-06 11:04:46 BUG #4095: Out of memory when restore db