creating a constraint on the same table - Mailing list pgsql-novice

From Matt Friedman
Subject creating a constraint on the same table
Date
Msg-id 004801c08190$8abc16b0$e8804318@mattq3h8budilr
Whole thread Raw
List pgsql-novice
I have a category table with a primary key called cat_id
and another column called parent_id
 
the parent_id must be part of the cat_id column
 
it's alot like a foreign key constraint but I don't know the sql to do it.
any ideas?
 
Is this a novice question or should I try a different list?

Matt Friedman
Spry New Media
http://www.sprynewmedia.com
Lead Programmer/Partner
email:
matt@sprynewmedia.com
phone: 250 744 3655
fax: 250 370 0436
 
 

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Yikes! Bitten by line length?
Next
From: Tom Lane
Date:
Subject: Re: ERROR: plpgsql: cache lookup from pg_proc failed -- Why?