> "Wayne Armstrong" <wdarmst@bacchus.com.au> writes:
> > It seems that postgress doesn't accept aliases for the tablename in updates,
> > inserts, and deletes as it does do for selects ????
>
> Nope, and neither does the SQL standard ...
>
But it would be VERY useful for the UPDATE command... Postgres has that
nice extension of multi-table where clause for updates, but it can be
confusing when you want to specify the updated table for a self-join.
Being able to alias the updated table too would make things cleaner.
Cheers,
Csaba.