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

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: (view raw, whole thread or download thread mbox)
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 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

pgsql-bugs by date

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

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