Re: Problem with self-join updates...

Thanks, this works... I did not know about the implicit table reference...

Now, I'm waiting for outer join updates and deletes so I don't have to use
in and sub-selects...

PostgreSQL rules...

Benoit

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Benoit Menendez" <benoitm(at)pacbell(dot)net>
Cc: <pgsql-sql(at)postgresql(dot)org>
Sent: Tuesday, February 19, 2002 11:06 AM
Subject: Re: [SQL] Problem with self-join updates...

> Benoit Menendez <benoitm(at)pacbell(dot)net> writes:
> > 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)
>
> > Table name "table" specified more than once
>
> Wasn't this answered already? You should not have the "from TABLE"
> in there. Essentially, there's already an implicit FROM entry for
> the target table, you don't need another. "from TABLE parent"
> is sufficient here.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html