On Thu, Apr 22, 2004 at 16:46:31 -0400,
Glenn MacGregor <gtm(at)highstreetnetworks(dot)com> wrote:
> No problem this works great!
> Now I have changed my data to
> vid vname parentname
> 1 n1(at)test(dot)com
> 2 n2(at)test(dot)com n1
> 3 n3(at)test(dot)com n1
> 4 n4(at)test(dot)com n1
> 5 n5(at)test(dot)com n3
> Can I change my delete cascade constraint to do this substring query
> instead of an exact match?
> Is there anyway to accomplish what I need to do?
If the local part of the email address is a candidate key, separate it
from the domain name and make it the primary key.
In response to
pgsql-admin by date
|Next:||From: Eloy Mier Prez||Date: 2004-04-23 09:21:21|
|Subject: How configure Oracle 9i not case sensitive...|
|Previous:||From: Glenn MacGregor||Date: 2004-04-22 20:46:31|
|Subject: Cascade delete question|