Re: BUG #2789: problem with delete statement

Thanks for the info. Probably I misread the documentation of the Delete
clause.

Again thank you,
Lucian

On 12/3/06, Bruno Wolff III <bruno(at)wolff(dot)to> wrote:
>
> On Tue, Nov 28, 2006 at 00:21:27 +0000,
> Lucian Capdefier <luciancapdefier(at)gmail(dot)com> wrote:
> >
> > 1. I cannot user table alias in the FROM clause of the DELETE statement.
>
> That isn't in the SQL spec, but the extension to allow it has been added
> to 8.2 which will be released very shortly.
>
> > 2. I cannot user more than one, table in the FROM clause.
>
> The FROM clause lists the (single) table that rows are to be deleted from.
> If you want to join to other tables you should use the USING clause.
> USING was added a release or two ago, so if you have a really old release,
> if might not be available there. The solution in that case is to take
> advantage of the "missing from" feature and just use the table without
> giving the table name in a FROM or USING clause.
>
> For questions like this you are going to be better off asking on the
> general or novice lists instead of bugs. Less people are going to see
> the message on the bugs list, so you are less likely to get help with
> posts there.
>