Re: Data Types - Mailing list pgsql-general

From Mike Gould
Subject Re: Data Types
Date
Msg-id 20080623193731.d651135d@mail.allcoast.net
Whole thread Raw
In response to Data Types  ("Mike Gould" <mgould@allcoast.net>)
List pgsql-general
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@sss.pgh.pa.us]
To: Roberts, Jon [mailto:Jon.Roberts@asurion.com]
Cc: mgould@allcoast.net, pgsql-general General [mailto:pgsql-general@postgresql.org]
Sent: Mon, 23 Jun 2008 15:00:05 -0400
Subject: Re: [GENERAL] Data Types

"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

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

pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: dbsize command
Next
From: salman
Date:
Subject: Re: dbsize command