Re: update set x=(subquery on same table)

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: update set x=(subquery on same table)
Date: 2004-02-13 16:26:55
Message-ID: Pine.LNX.4.33.0402130925010.9707-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 13 Feb 2004, CSN wrote:

>
> That does the trick. I'd also like to figure out a way
> to set all parent_ids to NULL if no parent row can be
> found. I haven't been able to figure it out so far.

could a circular foreign key reference with one delete set null type thing
work? then it'd be automagic

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-02-13 16:30:02 Re: Too much CPU usage
Previous Message Andrew Sullivan 2004-02-13 16:24:05 Re: Quad Xeon vs. Dual Itanium