Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 37776B5DC53 for ; Thu, 1 Sep 2011 10:32:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 86064-01 for ; Thu, 1 Sep 2011 13:32:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail48.e.nsc.no (mail48.e.nsc.no [193.213.115.48]) by mail.postgresql.org (Postfix) with ESMTP id 533EEB5DC45 for ; Thu, 1 Sep 2011 10:32:17 -0300 (ADT) Received: from balapapa.localnet (107.100.202.84.customer.cdi.no [84.202.100.107]) (authenticated bits=0) by mail48.nsc.no (8.14.4/8.14.4) with ESMTP id p81DWGbP015119 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Thu, 1 Sep 2011 15:32:16 +0200 (MEST) From: Leif Biberg Kristensen To: pgsql-sql@postgresql.org Subject: Re: Want some basic compare of data type on PostgreSQL and MySQL Date: Thu, 1 Sep 2011 15:32:15 +0200 User-Agent: KMail/1.13.7 (Linux/2.6.39-gentoo-r3; KDE/4.6.5; x86_64; ; ) References: <1314854108076-4757149.post@n5.nabble.com> In-Reply-To: MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <201109011532.15815.leif@solumslekt.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201109/6 X-Sequence-Number: 35806 On Thursday 1. September 2011 11.16.23 Scott Marlowe wrote: > The postgresql type text is a varchar with > no precision that can hold up to about a gig or so of text. Not that > i recommend putting a gig of text into a single field in a database. Printed out as plain text on paper with 4,000 characters per page, it would produce about 500 volumes of 500 pages each. That would take up 20 running metres of shelf space. In order to avoid global deforestation, please restrain your urge to print out those big text fields. regards, Leif