Re: Help with "missing FROM clause" needed - Mailing list pgsql-sql

From Greg Stark
Subject Re: Help with "missing FROM clause" needed
Date
Msg-id 87veuro9e4.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Help with "missing FROM clause" needed  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
"A. Kretschmer" <andreas.kretschmer@schollglas.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



pgsql-sql by date:

Previous
From: Emil Rachovsky
Date:
Subject: Syntax error in Execute statement
Next
From: Michael Fuhr
Date:
Subject: Re: [GENERAL] Syntax error in Execute statement