Hi!
I want to make a table with a column that references to multiple tables. Is
that possible? Look at the 3rd row:
1. create table dog(barking_volume int,slobber_amount int);
2. create table cat(laziness int);
3. create table animals(name text,ref_animal oid references cat(oid) and
dog(oid) );
---
I want to use references to ensure that i can not delete a row from dog or
cat tables if it is referenced from animals-table.
---
Also I could reference straight to the general oid-value but I think it
isn't possible either - like:
create table animals(name text,ref_animal oid references <alltables>.oid);
---
i and my cat Naukki (laziness == 98) will be glad for any help.
ville jungman, ulvilantie 3 b 11, 00350 helsinki, finland
tel. + 358 - 9 - 225 4482 , http://www.kolumbus.fi/vilmak
usko Herraan Jeesukseen, niin sin� pelastut. (apt. 16:31)
_________________________________________________________________
MSN 8: advanced junk mail protection and 2 months FREE*.
http://join.msn.com/?page=features/junkmail