I have a table category with columns -
category_id , main_id
I would like to check that the main_id value exists in category_id in
any row of the table category.
Is it possible to have a foreign key referring to the current table ?
Or should I be using a trigger to do it ?
I'm thinking I have to use a trigger to do it - but want to make sure.
In response to
pgsql-novice by date
|Next:||From: mwaples||Date: 2001-01-03 11:25:32|
|Subject: Re: constraint question|
|Previous:||From: David Merrill||Date: 2001-01-03 03:32:21|
|Subject: Re: ColdFusion sez this is valid SQL|