agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Benoit Menendez <benoitm@pacbell.net>
To: pgsql-sql@postgresql.org
Subject: Re: Problem with self-join updates...
Date: Tue, 19 Feb 2002 11:35:32 -0800
Message-ID: <001901c1b97c$98828b60$0d01a8c0@Kestrel> (raw)
References: <002101c1b650$18f087a0$0201a8c0@osprey>
	<002b01c1b973$bf48c740$0201a8c0@osprey>
	<6776.1014145606@sss.pgh.pa.us>

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@sss.pgh.pa.us>
To: "Benoit Menendez" <benoitm@pacbell.net>
Cc: <pgsql-sql@postgresql.org>
Sent: Tuesday, February 19, 2002 11:06 AM
Subject: Re: [SQL] Problem with self-join updates...


> Benoit Menendez <benoitm@pacbell.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

view thread (5+ messages)

Message-ID: <001901c1b97c$98828b60$0d01a8c0@Kestrel>
Permalink:  ../001901c1b97c$98828b60$0d01a8c0@Kestrel/
Also on:    postgresql.org/message-id/001901c1b97c$98828b60$0d01a8c0@Kestrel

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: benoitm@pacbell.net
  Subject: Re: Problem with self-join updates...
  In-Reply-To: <001901c1b97c$98828b60$0d01a8c0@Kestrel>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox