On Thu, Apr 22, 2004 at 16:46:31 -0400, Glenn MacGregor <[EMAIL PROTECTED]> wrote: > > No problem this works great! > > Now I have changed my data to > > vid vname parentname > 1 [EMAIL PROTECTED] > 2 [EMAIL PROTECTED] n1 > 3 [EMAIL PROTECTED] n1 > 4 [EMAIL PROTECTED] n1 > 5 [EMAIL PROTECTED] n3 > > Can I change my delete cascade constraint to do this substring query > instead of an exact match?
No. > 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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings