From: Glenn MacGregor <gtm@highstreetnetworks.com>
To: pgsql-sql@postgresql.org
Subject: Cascade delete question
Date: Thu, 22 Apr 2004 17:23:15 -0400
Message-ID: <408837C3.6010007@highstreetnetworks.com> (raw)
Hi All,
I am using a cascade delete on the following table:
vid vname parentname
1 n1@test.com
2 n2@test.com n1@test.com
3 n3@test.com n1@test.com
4 n4@test.com n1@test.com
5 n5@test.com n3@test.com
So the delete cascade states if I am deleting a row whose vname matches
the parentname delete those rows and it works fine.
I just changed the values of parentname (but the vname values stay the same)
vid vname parentname
1 n1@test.com
2 n2@test.com n1
3 n3@test.com n1
4 n4@test.com n1
5 n5@test.com n3
Is there a way to do the same cascade delete with these values? I can
select the correct info from vname in a query:
select substring(vname, from 0 for position('@' in vname)) from table1;
This works, so I tried to put that in the cascade but it failed.
Is there any way to accomplish this?
Thanks
Glenn MacGregor
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gtm@highstreetnetworks.com
Subject: Re: Cascade delete question
In-Reply-To: <408837C3.6010007@highstreetnetworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox