Re: Question on simulating Enum Data type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Morgan Kita" <mkita(at)verseon(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Question on simulating Enum Data type
Date: 2005-03-18 02:58:15
Message-ID: 484.1111114695@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Morgan Kita" <mkita(at)verseon(dot)com> writes:
> However, I am a little concerned about performance in that case. If I
> use domain constraints and keep the choices as strings then a string
> comparison will be done whenver I query on this field right?

Hm? A domain constraint would cost cycles when storing into the table,
but not when querying it. Joining to another table, on the other hand,
will cost you during queries.

If the strings are long, so that the amount of extra space involved adds
up to a lot, it'd probably make sense to go with integer codes. But if
they're just a word or so then I'd lean to keeping it simple.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Cima 2005-03-18 04:35:43 Reference and arrays
Previous Message Michael Glaesemann 2005-03-18 02:39:46 Re: Question on simulating Enum Data type