[SQL] protected ON DELETE CASCADE

here's my problem i have tables A, B, C, D A <- B A <- C <- D i want to maintain integrity so that if A is deleted from then so is anything referencing from B and C - no problem ON DELETE CASCADE but if there are any D's that point back to A (through composite key in C) i don't want the delet

[SQL] just checking

At times things seem just too easy, so I want to confirm that this is the correct syntax. I am looking for the interval (aging) for these invoices. I guess I am concerned because I guessed at the syntax. Is there a better way to do this? billdate is type 'date' SELECT ('now'-billdate) FROM f

Re: [SQL] How to execute a system file in procedure?

On Mon, Aug 20, 2001 at 10:08:36AM -0400, Raymond Chui wrote: > I would like execute a system command or my program or my shell > script in procedure. How do I do that? use . Albert. ---(end of broadcast)---

Re: [SQL] Altering pg_conndefaults

macky writes: > how do i alter values of pg_conndefaults? What exactly do you mean by pg_conndefaults? > example user=user1 to user=user2 The default user is normally the user with the same name as the current Unix user, or the PGUSER environment variable if set, but the details may vary from