constraint question

mwaples@optusnet.com.au

From: mwaples@optusnet.com.au
To: Pgsql-novice <pgsql-novice@postgresql.org>
Date: 2001-01-03T10:37:27Z
Lists: pgsql-novice
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.