Re: Writeable CTE Not Working?

From: Kong Man <kong_mansatiansin(at)hotmail(dot)com>
To: <vyegorov(at)gmail(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Writeable CTE Not Working?
Date: 2013-01-29 19:29:40
Message-ID: DUB116-W10DDC6C15D2D368AD772C08B1F0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi Victor,

> I see 2 problems with this query:
> 1) CTE is just a named subquery, in your query I see no reference to
> the “upd_code” CTE.
> Therefore it is never gets called;

So, in conclusion, my misconception about CTE in general was that all CTE get called without being referenced.

Thank you much for the explanation.
-Kong

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2013-01-30 01:16:40 Re: Writeable CTE Not Working?
Previous Message Виктор Егоров 2013-01-29 07:40:20 Re: Writeable CTE Not Working?