Problem with self-join updates...

Can someone please help?

Benoit
----- Original Message -----
From: Benoit Menendez
To: pgsql-sql(at)postgresql(dot)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