Chained table entries

Or maybe some other thingy.

I have a table that I want to refer to one of it's own attributes.  I
thought of RI but there has to be a top level entry that shouldn't be in
the table.  Then I thought of a check constraint using a select with
UNION but that dies (probably because UNIONs in views aren't ready for
primetime yet).  So finally I figured a RULE would work but I've never
done one and am waiting on Bruce's book before trying.
   But I'm not above accepting suggestions - or code.

The table has a primary key attribute whos values could be used in another
column or have a VALUE of 'NEWthingy'.

If I could do the RI as a view the code would be

create view THINGYS
    as select tbl_key
  from maintable
 UNION select 'NEWthingy'
;

Will a Rule handle this?


TIA,
Rod
--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814