A dynamic SQL/ecpg question

Поиск
Список
Период
Сортировка
От Murphy Pope
Тема A dynamic SQL/ecpg question
Дата
Msg-id OE70kVx3OfSap7LhLNy0000ad00@hotmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "S. Bulterman"
Дата:
Сообщение: Re: Problem with pgaccess
Следующее
От: Bruce Momjian
Дата:
Сообщение: Problem with python compile