Re: [HACKERS] Table aliases in delete statements?

> >Unless your query is going to be long enough to run into query length
> >limits, aliases are not your friends.  Standard SQL they may be, but
> >aliases always end up obscuring queries to those who come along after
> >you. 
> 
> The problem is that it's difficult to refer to the same table twice
> in a single query without using aliases.
> 
> The trap I fell into was thinking I had to alias both references to
> the table.
> 
> I'd be interested in seeing alternative solutions to the duplicate
> removal problem.

Yes, that is tricky in that there is an aliased version and a non-alias
version of the same table.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@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