Skip site navigation (1) Skip section navigation (2)

Re: Data Types

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Data Types
Date: 2010-11-07 11:00:38
Message-ID: ib60sm$qdi$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On 2010-11-05, ALT SHN <i(dot)geografica(at)alt-shn(dot)org> wrote:
> --20cf30549a6f4e574504944fc733
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: quoted-printable
> Hello List,
> I have a column of a table of paleontological sites named "Paleosites" wich
> has a column named "species". A paleosite can contain remais of one or more
> animals. So in that column sometimes I have to put this: dinossauria
> crocodilia plantae. This indicates that from a given paleosite were
> retrieved the remais of 3 different species.
> Now my question is: wich data type should the column "Species" be? Text?
> Varchar?

For 3NF it should be in a separate table.

Text and varchar are the same just varchar takes longer to type on the

text[]  (array of text) is another option (but both above comments
still apply).

ɹǝpun uʍop ɯoɹɟ sƃuıʇǝǝɹ⅁

In response to

pgsql-novice by date

Next:From: Jasen BettsDate: 2010-11-07 11:14:16
Subject: Re: Describe command alternatives in postgresql
Previous:From: Jasen BettsDate: 2010-11-07 10:55:24
Subject: Re: COPY command and serial columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group