OCTET_LENGTH is wrong - Mailing list pgsql-hackers

From Peter Eisentraut
Subject OCTET_LENGTH is wrong
Date
Msg-id Pine.LNX.4.30.0111171827540.5592-100000@peter.localdomain
Whole thread Raw
Responses Re: OCTET_LENGTH is wrong
Re: OCTET_LENGTH is wrong
List pgsql-hackers
I noticed OCTET_LENGTH will return the size of the data after TOAST may
have compressed it.  While this could be useful information, this
behaviour has no basis in the SQL standard and it's not what is
documented.  Moreover, it eliminates the standard useful behaviour of
OCTET_LENGTH, which is to show the length in bytes of a multibyte string.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Palle Girgensohn
Date:
Subject: Multilingual application, ORDER BY w/ different locales?
Next
From: Peter Eisentraut
Date:
Subject: No documentation in beta tarballs