| 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: | Whole Thread | Raw Message | 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.
| 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 |