Problem with self-join updates...

----- Original Message -----

From: Benoit Menendez

To: pgsql-sql@postgresql.org

Sent: Friday, February 15, 2002 10:39 AM

Subject: [SQL] Problem with self-join updates...

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