| From: | ALT SHN <i(dot)geografica(at)alt-shn(dot)org> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Data Types |
| Date: | 2010-11-05 15:17:53 |
| Message-ID: | AANLkTimurMMmqdaALobFGM7o0=i7CMyPj_VAycVC=iJZ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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 | Oliveiros d'Azevedo Cristina | 2010-11-05 16:40:50 | Re: Data Types |
| Previous Message | Tom Lane | 2010-11-04 20:43:41 | Re: How to do A union (B - ( A intersect B )) or sort of :-) |