Thanks people, but the trigger doesnt really solve my problem. You see,
there is actually a CHAIN of dependencies where B references A, C references
B, D and E reference C and so on... So if i start writing triggers for all
these, there'll be a huge process to follow. I'm not strictly against i
Hello,
I have 2 tables (A and B) where the table B has a foreign key reference to
table A. Like this:
create table A (x int primary key);
create table B (y int primary key, z int references A (x) );
As you can see, i've not specified any further 'on delete' clause to the
foreign key constraint
Hi,
I'm using Enterprise DB PostgresPlus version 8.3.
Is there is a simple function or command like previous_date(mydate) which
when passed a particular date, simply returns the previous date? I tried
mydate - 1
but this doesnt work.
Thanks,
Shruthi
Hello,
I have a query where I full-outer-join 2 tables, and all the columns other
than the join column are numerical columns. For my further calculations i
need to pad the unmatched tuples with 0 (zero) instead of NULL so that I can
perform meaningful mathematical calculations on them. Is this cur
