Re: Help with "missing FROM clause" needed

From: Greg Stark <gsstark(at)mit(dot)edu>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Help with "missing FROM clause" needed
Date: 2006-03-06 15:55:31
Message-ID: 87veuro9e4.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> writes:

> *untested*
> DELETE FROM partner_zu using partner
> WHERE partner_zu.pa_id = partner.id
> ...
> The point is the 'using ...'

You can also just set the add_missing_from to true for that one session if you
prefer. I don't think there's any plans to remove the option, it's just not
the default any more.

--
greg

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2006-03-06 18:30:42 Re: Syntax error in Execute statement
Previous Message Emil Rachovsky 2006-03-06 15:21:58 Syntax error in Execute statement