am 28.02.2006, um 14:01:44 +0100 mailte [EMAIL PROTECTED] folgendes: > update t1 > set t1f1='test' > where t1.t1f2=t2.t2f2 > and t1.t1f3=t2.t2f3; > > unfortunately, now I get the error that t2 is not in the FROM clause.
You can set add_missing_from in yout postgresql.conf, but please read http://www.postgresql.org/docs/8.1/interactive/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
