Postgres Pro
Downloads
Home   >   mailing lists

Re: Using a CTE for an update - Mailing list pgsql-general

From Victor Yegorov
Subject Re: Using a CTE for an update
Date
Msg-id CAGnEbohkPQCEdF7qP=1hAgcnmxnWTj4GWByf7wRybc56OpEROg@mail.gmail.com
Whole thread Raw
In response to Using a CTE for an update  (David Salisbury <salisbury@globe.gov>)
List pgsql-general
Tree view
2013/6/1 David Salisbury <salisbury@globe.gov>
I would think this would be possible.  I'm on 9.0.8

Data-Modifying CTEs are available since 9.1: http://www.depesz.com/2011/03/16/waiting-for-9-1-writable-cte/

Please note, that CTE acts as an optimization fence, therefore you might experience query slowdown.


--
Victor Y. Yegorov

pgsql-general by date:

Previous
From: Bosco Rama
Date:
Subject: Re: Using a CTE for an update
Next
From: Jeff Janes
Date:
Subject: Re: Using a CTE for an update