Re: Allow an alias for the target table in UPDATE/DELETE - Mailing list pgsql-patches

From Tom Lane
Subject Re: Allow an alias for the target table in UPDATE/DELETE
Date
Msg-id 5264.1137914626@sss.pgh.pa.us
Whole thread Raw
In response to Re: Allow an alias for the target table in UPDATE/DELETE  (Neil Conway <neilc@samurai.com>)
Responses Re: Allow an alias for the target table in UPDATE/DELETE  (Neil Conway <neilc@samurai.com>)
List pgsql-patches
Neil Conway <neilc@samurai.com> writes:
> Can you see a better fix?

I haven't done any experimentation, but my first instinct would be to
spell out the productions at greater length: instead of

    relation_expr opt_as ColId

try

    relation_expr ColId
    | relation_expr AS ColId

The normal game with bison is to postpone decisions (reductions) as
long as possible.  Shortcuts like opt_as lose that game because the
shift-versus-reduce decision has to be made with hardly any lookahead.

Or maybe some other hack is needed, but I seriously doubt it's
unfixable.

            regards, tom lane

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: Allow an alias for the target table in UPDATE/DELETE
Next
From: Neil Conway
Date:
Subject: Re: Allow an alias for the target table in UPDATE/DELETE