Re: Help with "missing FROM clause" needed

am 06.03.2006, um 14:25:52 +0100 mailte Thomas Beutin folgendes:
> Hi,
>
> to be compatible with the postgres standard syntax in 8.1.x i need some
> help for rewriting my "delete" statements ("select" is not a problem). I
> use the following statement:
>
> DELETE FROM partner_zu
> WHERE partner_zu.pa_id = partner.id
> AND partner_zu.m_id = '25'
> AND partner.open = 'm'
> AND partner.a_id = partner_zu.a_id
> AND partner_zu.a_id = '104335887112347';

*untested*

delete from partner_zu using partner ...

Example:

test=# delete from only f1 where f1.id = f2.id ;
ERROR: missing FROM-clause entry for table "f2"

but:

test=# delete from only f1 using f2 where f1.id = f2.id ;
DELETE 0

Hint: read
http://www.postgresql.org/docs/8.1/interactive/runtime-config-compatible.html

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===