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

From Neil Conway
Subject Re: Allow an alias for the target table in UPDATE/DELETE
Date
Msg-id 1137915811.8798.41.camel@localhost.localdomain
Whole thread Raw
In response to Re: Allow an alias for the target table in UPDATE/DELETE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Sun, 2006-01-22 at 02:23 -0500, Tom Lane wrote:
>     relation_expr opt_as ColId
>
> try
>
>     relation_expr ColId
>     | relation_expr AS ColId

Yeah, I already tried that without success. The no-AS-specified variant
is still ambiguous: given SET following relation_expr, the parser still
can't determine whether the SET is the table alias or is part of the
UpdateStmt.

-Neil



pgsql-patches by date:

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