Re: OCTET_LENGTH is wrong - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: OCTET_LENGTH is wrong
Date
Msg-id 3BFAB58C.8020604@tm.ee
Whole thread Raw
In response to Re: OCTET_LENGTH is wrong  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tatsuo Ishii wrote:

>>>There have been three ideas of what octet_length() sould return:
>>>
>>>    1) compressed on-disk storage length
>>>    2) byte length in server-side encoding
>>>    3) byte length in client-side encoding
>>>
>> Very nice is possibility of choice... What add everything:
>>
>>    octet_length_storage()
>>    octet_length_server()
>>    octet_length_client()
>>
>
>We only need one of octet_length_server() or octet_length_client().
>
And i guess that octet_length_server() is cheaper as it does not do a 
convert()
when not needed.

>
>We could emulate the rest using convert() etc.
>--
>Tatsuo Ishii
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>




pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Btree doesn't work with ">" condition
Next
From: Fábio Santana
Date:
Subject: RULES