Postgres Pro
Downloads
Home   >   mailing lists

Problem with self-join updates... - Mailing list pgsql-sql

From Benoit Menendez
Subject Problem with self-join updates...
Date
Msg-id 002101c1b650$18f087a0$0201a8c0@osprey
Whole thread Raw
Responses Re: Problem with self-join updates...  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Tree view
I have the following self-join update:
 
            update TABLE set PARENT_ID=parent.PARENT_ID
            from TABLE, TABLE parent
            where TABLE.PARENT_ID=parent.ID
            and parent.ID in (1,2,3,4)
This query is use to update a hierarchy before deleting specific records...
 
I get the following error:
 
    Table name "table" specified more than once
 
This appears to be a limitation of the update syntax which is not documented...
 
Is this something that will be fixed soon? or should I write this query differently?
 
Any suggestions?
 
Thanks for your help.
 
    Benoit

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: create index on function - why?
Next
From: Stephan Szabo
Date:
Subject: Re: Problem with self-join updates...