Re: [GENERAL] v9.1.3 WITH with_query UPDATE

2012-06-16 Thread Bill House
On 06/16/2012 01:27 PM, Vibhor Kumar wrote: > On Jun 16, 2012, at 1:11 PM, Bill House wrote: > >> md5sum may be duplicated and I am trying to mark the column "del" of the >> redundant records leaving one unmarked. >> >> Here is one variation of the syntax I have tried on one group: >> >> WITH

Re: [GENERAL] v9.1.3 WITH with_query UPDATE

2012-06-16 Thread Vibhor Kumar
On Jun 16, 2012, at 1:11 PM, Bill House wrote: > md5sum may be duplicated and I am trying to mark the column "del" of the > redundant records leaving one unmarked. > > Here is one variation of the syntax I have tried on one group: > > WITH batch AS (select * from files_test where >

Re: [GENERAL] v9.1.3 WITH with_query UPDATE

2012-06-16 Thread Yeb Havinga
On 2012-06-16 19:11, Bill House wrote: Would someone please point me to (or supply) some working examples of UPDATE commands using the WITH clause syntax as described in the manual (pdf version page 1560) and referring to Section 7.8 (pdf version page 104)? http://www.depesz.com/2011/03/16/wait

[GENERAL] v9.1.3 WITH with_query UPDATE

2012-06-16 Thread Bill House
Hello all, Would someone please point me to (or supply) some working examples of UPDATE commands using the WITH clause syntax as described in the manual (pdf version page 1560) and referring to Section 7.8 (pdf version page 104)? I have looked around a lot and haven't seen much on this. I have a