BUG #4715: libpq `PQgetlength' return invalid field length. - Mailing list pgsql-bugs

From VEN
Subject BUG #4715: libpq `PQgetlength' return invalid field length.
Date
Msg-id 200903180303.n2I33FSR088828@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4715: libpq `PQgetlength' return invalid field length.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4715
Logged by:          VEN
Email address:      bsditer@gmail.com
PostgreSQL version: 8.3.7
Operating system:   FreeBSD
Description:        libpq `PQgetlength' return invalid field length.
Details:

Database have below table:
CREATE TABLE TEST {
    NUM BIGINT NOT NULL DEFAULT 0
};


EXEC "SELECT NUM FROM TEST LIMIT 1"
   PQgetlength return valid length (sizeof(int64)), it's ok.

but
EXEC "SELECT SUM(NUM)::BIGINT FROM TEST"
or
EXEC "SELECT SUM(NUM) FROM TEST"

   PQgetlength already return zero.

pgsql-bugs by date:

Previous
From: "Roger Chang"
Date:
Subject: BUG #4713: Unicode Big5 Conversion
Next
From: "Roger Chang"
Date:
Subject: BUG #4714: Unicode Big5 Conversion