> > > If the goal is (a) then your way is better, but I like mine if the goal
> > > is (b). Seems like some discussion is needed here about just what we
> > > want to accomplish.
> >
> > I agree the goal is (b). However, I can not imagine a query with a FROM
> > clause that would ever want to use auto-creation of range entries.
>
> how about:
>
> delete from taba where a=tabb.a;
>
> I think the implicit auto-creation should only be disallowed/warned in
> select statements that have a from clause, not update and delete.
I meant a SELECT FROM clause. A DELETE FROM is not the same, and does
not mark the entry as inFromCl. I should have been more specific.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026