OCTET_LENGTH is wrong

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: OCTET_LENGTH is wrong
Date: 2001-11-17 17:33:02
Message-ID: Pine.LNX.4.30.0111171827540.5592-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-11-17 17:39:37 No documentation in beta tarballs
Previous Message Palle Girgensohn 2001-11-17 16:50:38 Multilingual application, ORDER BY w/ different locales?