From: | "Oliveiros d'Azevedo Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> |
---|---|
To: | "ALT SHN" <i(dot)geografica(at)alt-shn(dot)org>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Data Types |
Date: | 2010-11-05 16:40:50 |
Message-ID: | 316D8F1BDEA349169C8B43F573CF0B1E@marktestcr.marktest.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Why don't you use a separate table "species" with an associative table in between "species" and "Paleosites" ?
Is there any reason preventing it I am missing?
Best,
Oliveiros
----- Original Message -----
From: ALT SHN
To: pgsql-novice(at)postgresql(dot)org
Sent: Friday, November 05, 2010 3:17 PM
Subject: [NOVICE] Data Types
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?
Thank you in advance,
Best Regards,
André Mano
--
---------------------------------------------------------------
Associação Leonel Trindade
SOCIEDADE DE HISTÓRIA NATURAL
Apartado 25 2564-909 Torres Vedras Portugal
Sede e Biblioteca: rua Cavaleiros da Espora Dourada, 27A 2560 Torres Vedras
Laboratório de Paleontologia e Paleoecologia: Polígono Industrial do Alto do Ameal 2565-641 Ramalhal
http://alt-shn.blogspot.com
www.alt-shn.org
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2010-11-05 16:47:40 | Re: Data Types |
Previous Message | ALT SHN | 2010-11-05 15:17:53 | Data Types |