Type of bare text strings

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Type of bare text strings
Date: 2006-06-08 15:50:33
Message-ID: 20060608155032.GO45331@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

decibel=# select pg_column_size('test'::varchar);
8

decibel=# select pg_column_size('test'::text);
8

decibel=# select pg_column_size('test'::name);
64

decibel=# select pg_column_size('test'::char(4));
8

decibel=# select pg_column_size('123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
301

decibel=#
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2006-06-08 15:55:50 Re: More on inheritance and foreign keys
Previous Message Tom Lane 2006-06-08 15:48:57 Re: ADD/DROP INHERITS