Re: Type of bare text strings

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