Postgres Pro
Downloads
Home   >   mailing lists

Data Types - Mailing list pgsql-novice

From ALT SHN
Subject Data Types
Date
Msg-id AANLkTimurMMmqdaALobFGM7o0=i7CMyPj_VAycVC=iJZ@mail.gmail.com
Whole thread Raw
Responses Re: Data Types  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Data Types  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Re: Data Types  (Andreas <maps.on@gmx.net>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to do A union (B - ( A intersect B )) or sort of :-)
Next
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: Data Types