Search Postgresql Archives

Re: Data Types

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx]
To: Roberts, Jon [mailto:Jon.Roberts@xxxxxxxxxxx]
Cc: mgould@xxxxxxxxxxxx, pgsql-general General [mailto:pgsql-general@xxxxxxxxxxxxxx]
Sent: Mon, 23 Jun 2008 15:00:05 -0400
Subject: Re: [GENERAL] Data Types

"Roberts, Jon" <Jon.Roberts@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux