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