column type varchar(128) not null default '' vs varchar(128)

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: column type varchar(128) not null default '' vs varchar(128)
Date: 2006-03-08 22:52:02
Message-ID: 440F6012.1070502@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

When setuping column types, is there the big efficiency difference
between the following two examples?

col varchar(128) NOT NULL default ''
vs.
col varchar(128)

Thanks a lot,
Ying

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2006-03-08 22:59:44 Re: column type varchar(128) not null default '' vs varchar(128)
Previous Message Jim Nasby 2006-03-08 22:17:39 Re: database/schema level triggers?