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$2@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
keyboard.
text[] (array of text) is another option (but both above comments
still apply).
--
ɹǝpun uʍop ɯoɹɟ sƃuıʇǝǝɹ⅁
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2010-11-07 11:14:16 | Re: Describe command alternatives in postgresql |
Previous Message | Jasen Betts | 2010-11-07 10:55:24 | Re: COPY command and serial columns |