Difference between check and a small table - Mailing list pgsql-general

From
Subject Difference between check and a small table
Date
Msg-id 20031017165803.B4D1746E16@mail.passofundo.rs.gov.br
Whole thread Raw
List pgsql-general
Hello,

Suppose I have one table, and one field (of this table) which accepts only a
certain range of values (they do not need to be continuous though).
What is the difference in the number of operations performed by postgres on
insert/update of data to this field if I use:
- check clauses
OR
- a foreign key referencing another small table with those values?

Is there any significant performance improvement in using one method instead
of another?

Thanks in advance,
Enio

pgsql-general by date:

Previous
From: "Bill Nedell"
Date:
Subject: selecting table at execution with PL/PgSQL
Next
From:
Date:
Subject: How to activate error messages in my language