Thread: Port Bug Report: NULL fields don't return anything. Later fields move to left.
Port Bug Report: NULL fields don't return anything. Later fields move to left.
From
Unprivileged user
Date:
============================================================================ 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. --------------------------------------------------------------------------