Re: constraint via selection

I don't know much about this issue. but perhaps, since I assume the country codes are static, it would be faster if you
justchecked each individual value (especially if there are few of them) like so
 

CHECK code = 'no' OR code = 'de' OR code = 'se', etc.

I don't know.

Regards,

Aasmund.
On Sun, 18 Nov 2001 00:00:57 +1100, Horst Herb <hherb@malleenet.net.au> wrote:
> 
> Sorry, I probably should reformulate my question into "is there a more 
> effficient constraint than a foreign key constraint for this simple 
> problem"?
> 
> Horst
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46