Search Postgresql Archives

Re: Using a CTE for an update

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: David Salisbury <salisbury@xxxxxxxxx>
Subject: Re: Using a CTE for an update
From: Victor Yegorov <vyegorov@xxxxxxxxx>
Date: Sat, 1 Jun 2013 00:59:41 +0300
Cc: PostgreSQL general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <51A91808.2050003@globe.gov>

2013/6/1 David Salisbury <salisbury@xxxxxxxxx>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Using a CTE for an update
  - From: David Salisbury

Prev by Date: Re: Using a CTE for an update
Next by Date: Re: Using a CTE for an update
Previous by thread: Re: Using a CTE for an update
Next by thread: Re: Using a CTE for an update
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux