Re: Query runs too long for indexed tables - Mailing list pgsql-performance

> Why not use a LEFT JOIN for this ?

UPDATE firma1.rid SET rid.toode=NULL
LEFT join firma1.toode using(toode)
         WHERE rid.toode IS NOT NULL AND toode.toode IS NULL;

Causes:

ERROR:  syntax error at or near "LEFT" at character 41

outer joins are not supported in Postgres UPDATE command.

Andrus.