On 2010-11-05, ALT SHN <i(dot)geografica(at)alt-shn(dot)org> wrote:
> 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?
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
ɹǝpun uʍop ɯoɹɟ sƃuıʇǝǝɹ⅁
In response to
pgsql-novice by date
|Next:||From: Jasen Betts||Date: 2010-11-07 11:14:16|
|Subject: Re: Describe command alternatives in postgresql|
|Previous:||From: Jasen Betts||Date: 2010-11-07 10:55:24|
|Subject: Re: COPY command and serial columns|