| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
| Cc: | David Fetter <david(at)fetter(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Rusty Conover <rconover(at)infogears(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Expanding DELETE/UPDATE returning |
| Date: | 2007-03-02 18:47:21 |
| Message-ID: | 20070302184721.GA31806@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Feb 27, 2007 at 15:07:06 +0100,
"Florian G. Pflug" <fgp(at)phlo(dot)org> wrote:
>
> select * from t1, (delete from t2 returning t2.t1_id) where t1.id =
> t2.t1_id limit 1 ;
>
> I for my part couldn't even say what I'd expect that query to do.
I would expect it to delete all rows from t2 but only return 1 row as output.
I think the ambiguous cases are going to come from cases where deleting
some rows in a subquery changes which rows will be deleted in subsequent
executions of the same subquery. Something like deleting the row with the
least value for some column.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-02 18:49:14 | Re: GIST and TOAST |
| Previous Message | Andrew - Supernews | 2007-03-02 18:41:08 | Re: GIST and TOAST |