am 28.02.2006, um 14:01:44 +0100 mailte pg@os10000.net 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 ===