Re: Number of fields in a record

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Number of fields in a record
Date: 2011-01-05 20:42:05
Message-ID: 20110105204205.GA5474@aart.is.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Jan 05, 2011 at 02:20:32PM -0600, JORGE MALDONADO wrote:
> I am designing a table which will have about 70 fields per record and I
> wonder if this is a big number. The data types are boolean,
> varchar(maxlength), time, integer, smallint and numeric mainly.
> I will appreciate your comments to this respect.
>
> Respectfully,
> Jorge Maldonado

No, that is not a large number of fields. It is usually more
important that the table schema be normalized.

Cheers,
Ken

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lew 2011-01-07 00:26:16 Re: When to use postgreSQL
Previous Message JORGE MALDONADO 2011-01-05 20:20:32 Number of fields in a record