29 Jan
2006
29 Jan
'06
7:13 p.m.
i m using postgresql... i want one of my columns to reference diff tables and refernece them in or relation wat i mean is
that for the column foo in table foo_table the values should come from column ref1 in table 1 orref 2 in table 2 and so on
eg in foo_table id foo 1 123 (referneces table1) 2 124 (referneces table1) 3 223 (referneces table 2)
table 1 id ref1 otherfields id01 123 kasdhfaks id02 124 asdkjasl
table2 id ref2 02id01 223
so is there anyway i can specify these constraints
i hope i was clear in the description...
thanks -- Puneet