Alvaro Herrera wrote:
> Jim C. Nasby wrote:
> > What type are bare strings considered if they haven't been cast? I'm curious as
> > to how the first case is of size 5, and how the last case is 301...
> >
> > decibel=# select pg_column_size('test');
> > 5
>
> "unknown". This seems to be a cstring (i.e. length 5 considering the
> trailing \0)
Yup. This is handled by this code:
else if (typlen == -2) { /* cstring */ result = strlen(DatumGetCString(value)) + 1; }
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support