Home > mailing lists

Re: update set x=(subquery on same table) - Mailing list pgsql-general

From	scott.marlowe
Subject	Re: update set x=(subquery on same table)
Date	February 13, 2004 15:33:45
Msg-id	Pine.LNX.4.33.0402130925010.9707-100000@css120.ihs.com Whole thread Raw
In response to	Re: update set x=(subquery on same table) (CSN <cool_screen_name90001@yahoo.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Zak McGregor
Date: 13 February 2004, 15:30:45
Subject: Re: Join 2 aggregate queries?

From: "scott.marlowe"
Date: 13 February 2004, 15:38:19
Subject: Re: Quad Xeon vs. Dual Itanium

Re: update set x=(subquery on same table) - Mailing list pgsql-general

Previous

Next