On Fri, 20 Jul 2012 08:27:37 -0400 Benjamin Adams <freebsdworld@gmail.com> wrote:
> Hello,
>
> I'm looking to do something like:
>
> select month, mb_size(description) from data where year = 2012 group by month
>
> I also am looking for raw size not compressed size.
octet_length() will give you the size in bytes. It's not the size in
characters, though, unless the field is using an encoding that's always
1 byte per character. For character length, use (obviously)
character_length().
--
Bill Moran <wmoran@potentialtech.com>