[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] When is a constraint too big?
From:       lbottorff () harveycounty ! com
Date:       2001-01-30 22:51:03
[Download RAW message or body]

I'm building a rather large table with certain fields that have a set range of
possible values. Some have a possible range of 100 or more values. Should I
continue to list out the boolean gospel right there in a CONSTRAINT
statement, or is this a job for a trigger, i.e., put the possible values in a
mini lookup table and use a trigger?

L

[prev in list] [next in list] [prev in thread] [next in thread]