Re: Data Types - Mailing list pgsql-general

From Tom Lane
Subject Re: Data Types
Date
Msg-id 29459.1214247605@sss.pgh.pa.us
Whole thread Raw
In response to Re: Data Types  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgsql-general
"Roberts, Jon" <Jon.Roberts@asurion.com> writes:
> Character will use more disk space than varchar so it does make a
> difference.

char also has very peculiar comparison semantics.  Unless your strings
are really truly fixed-length, you should just about always use varchar.

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: dbsize command
Next
From: Mark Roberts
Date:
Subject: Re: limits?