Re: Want some basic compare of data type on PostgreSQL and MySQL - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Want some basic compare of data type on PostgreSQL and MySQL
Date
Msg-id CAOR=d=2WWGQSE+BzBX3q6QSL4wa2mMsLzb7GOZDPYC3eK0y8_A@mail.gmail.com
Whole thread Raw
In response to Re: Want some basic compare of data type on PostgreSQL and MySQL  (Leif Biberg Kristensen <leif@solumslekt.org>)
List pgsql-sql
On Thu, Sep 1, 2011 at 7:32 AM, Leif Biberg Kristensen
<leif@solumslekt.org> wrote:
> 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.

I'm sure with an appropriately small font we could cut that right
down, pardon the pun.


pgsql-sql by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: Want some basic compare of data type on PostgreSQL and MySQL
Next
From: Charlie
Date:
Subject: Schema partitioning