This is a multi-part message in MIME format.
-------------e594a4a6a08ae89ceaf4e68b91059c41
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Thanks for all of the replies.
Best Regards,
Michael Gould, Manager Information Technology
All Coast Intermodal Services, Inc.
904-226-0978
=5F=5F=5F=5F=5F =20
From: Tom Lane [mailto:tgl@[EMAIL PROTECTED]
Roberts, Jon [mailto:Jon.Roberts@[EMAIL PROTECTED]
mgould@[EMAIL PROTECTED]
pgsql-general General [mailto:pgsql-general@[EMAIL PROTECTED]
Mon, 23 Jun 2008 15:00:05 -0400
Subject: Re: [GENERAL] Data Types=20
"Roberts, Jon" <Jon.Roberts@[EMAIL PROTECTED]
> writes:
> Character will use more disk space than varchar so it does make a
> difference.
=20
char also has very peculiar comparison semantics. Unless your strings
are really truly fixed-length, you should just about always use varcha=
r.
=20
regards, tom lane
=20
--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
=20
-------------e594a4a6a08ae89ceaf4e68b91059c41
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html>
<head>
<meta http-equiv=3D'Content-Type' content=3D'text/html;charset=3Dus-asc=
ii'>
<style>BODY{font:10pt Tahoma, Verdana, sans-serif;}</style>
</head>
<body>
Thanks for all of the replies.<br><br>Best Regards,<br><br>Michael Gould=
, Manager Information Technology<br>All Coast Intermodal Services, Inc.<=
br>904-226-0978<br><blockquote style=3D"border-left: 2px solid rgb(0, 0,=
255); padding-left: 5px; margin-left: 5px; margin-right: 0px;"><hr><b>F=
rom:</b> Tom Lane [mailto:tgl@[EMAIL PROTECTED]
><b>To:</b> Roberts, Jon =
[mailto:Jon.Roberts@[EMAIL PROTECTED]
><b>Cc:</b> mgould@[EMAIL PROTECTED]
pgsq=
l-general General [mailto:pgsql-general@[EMAIL PROTECTED]
><b>Sent:</b> =
Mon, 23 Jun 2008 15:00:05 -0400<br><b>Subject:</b> Re: [GENERAL] Data Ty=
pes <br><br>"Roberts, Jon" <<a href=3D"mailto:Jon.Roberts@[EMAIL PROTECTED]
">Jon.Roberts@[EMAIL PROTECTED]
>> writes:<br>
> Character will use more disk space than varchar so it does make a<b=
r>
> difference.<br>
<br>
char also has very peculiar comparison semantics. Unless your strings<b=
r>
are really truly fixed-length, you should just about always use varchar.=
<br>
<br>
=09=09=09regards, tom lane<br>
<br>
-- <br>
Sent via pgsql-general mailing list (<a href=3D"mailto:pgsql-general@[EMAIL PROTECTED]
">pgsql-general@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-general"
target=3D"=
=5Fblank">http://www.postgresql.org/mailpref/pgsql-general</a><br>
</blockquote><style>
</style>
</body></html>
-------------e594a4a6a08ae89ceaf4e68b91059c41--


|