On Fri, 20 Jul 2012 08:27:37 -0400 Benjamin Adams <freebsdwo...@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 <wmo...@potentialtech.com> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
