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