Re: implicit tables syntax disappeared from 8.0->8.1

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    ===