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
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 |