============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Per Erik R�nne
Your email address : per@idp.dk
Category : runtime: front-end: C++
Severity : serious
Summary: NULL fields don't return anything. Later fields move to left.
System Configuration
--------------------
Operating System : AIX 4.1.3
PostgreSQL version : 6.4.2
Compiler used : gcc 2.7.7
Hardware:
---------
IBM 43P 7248-100, 160Mb RAM, 2x1Gb disk + 1x4Gb disk
uname -a:
AIX balder 1 4 0052054D4C00
Versions of other tools:
------------------------
GNU Make version 3.71
--------------------------------------------------------------------------
Problem Description:
--------------------
I've had major problems with tables containing rows with NULL fields. I receive the row in a string where each field
shoulduse an exact number of bytes. Through a firm-defined class the string is set up [it's actually a void type which
pointsto a stucture with the fields to use in the C++ program]. It works well for fixed length types, but I'm unsure
aboutvar-length data types. It's no I who have programmed the class.
But when nothing is returned the next field is placed in the former field's place.
--------------------------------------------------------------------------
Test Case:
----------
A greater description of the problem can be found on the mail list on interfaces. It whished, the program written can
besent for you.
--------------------------------------------------------------------------
Solution:
---------
You might declare all fields NOT NULL.
Admittedly, not a good solution.
--------------------------------------------------------------------------