Questions about "varchar" NOT NULL default = char(1) ?

From: Emi Lu <emilu(at)cs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Questions about "varchar" NOT NULL default = char(1) ?
Date: 2005-09-15 20:14:33
Message-ID: 4329D629.8030203@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

If one column "col1" is defined as :

col1 varchar(1) not null default ''

Does it means that col1's definition is equal to

col1 char(1) not null default ''

Put it another way, will char '' be saved as char(1) or char '' does not
use space at all?

Thanks a lot,
Emi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bart McFarling 2005-09-15 20:20:02 Re: Deadlock
Previous Message David Fetter 2005-09-15 19:46:43 Re: Howto create a plperlu function as user (not superuser)??