Re: Data Types

Thanks for all of the replies.

Best Regards,

Michael Gould, Manager Information Technology
All Coast Intermodal Services, Inc.
904-226-0978
_____

From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
To: Roberts, Jon [mailto:Jon(dot)Roberts(at)asurion(dot)com]
Cc: mgould(at)allcoast(dot)net, pgsql-general General [mailto:pgsql-general(at)postgresql(dot)org]
Sent: Mon, 23 Jun 2008 15:00:05 -0400
Subject: Re: [GENERAL] Data Types

"Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)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

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general