Re: [HACKERS] Efficient DELETE Strategies - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: [HACKERS] Efficient DELETE Strategies
Date
Msg-id 200206101833.g5AIXj600263@candle.pha.pa.us
Whole thread Raw
Responses Re: [HACKERS] Efficient DELETE Strategies  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hannu Krosing wrote:
> What about
> 
> DELETE relation_expr FROM relation_expr [ , table_ref [ , ... ] ]
>      [ WHERE bool_expr ]
> 
> or
> 
> DELETE relation_expr.* FROM relation_expr [ , table_ref [ , ... ] ]
>      [ WHERE bool_expr ]

So make the initial FROM optional and allow the later FROM to be a list
of relations?  Seems kind of strange.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@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
 


pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: VIEWs and FOREIGN keys
Next
From: Jan Wieck
Date:
Subject: Re: [GENERAL] VIEWs and FOREIGN keys