A dynamic SQL/ecpg question - Mailing list pgsql-interfaces

From Murphy Pope
Subject A dynamic SQL/ecpg question
Date
Msg-id OE70kVx3OfSap7LhLNy0000ad00@hotmail.com
Whole thread Raw
List pgsql-interfaces
Can anyone explain the difference between the following descriptor members?
 
LENGTH
OCTET_LENGTH
RETURNED_LENGTH
RETURNED_OCTET_LENGTH
 
From looking at the source code, the last two are identical and it looks like they return the length of an individual row/column value (i.e. for a varchar column, they would return the length of an actual varchar value).
 
I think OCTET_LENGTH will return the size of the column as stored in the database.
 
I can't quite figure out what LENGTH is supposed to do.  It returns PQfmod( ) - VARHDRSZ.  How is that different from the OCTET_LENGTH?
 
Thanks in advance.
 
            -- Murphy
 

pgsql-interfaces by date:

Previous
From: "S. Bulterman"
Date:
Subject: Re: Problem with pgaccess
Next
From: Bruce Momjian
Date:
Subject: Problem with python compile