On Mon, Jun 28, 1999 at 12:13:49PM +0300, Herouth Maoz wrote:
A minor nit here. postgresql doesn't like class qualifications on the
field name tagets in an update (at least with 6.4.2), so the set line
needs to lose the "b." part, as below:
>
> So, it appears that the correct syntax in Postgres would be:
>
> UPDATE b
> SET b.a_id = a.aid
SET a_id=a.aid
> FROM a
> WHERE b.custno = a.custno;
>
Ross