| From: | Nico Williams <nico(at)cryptonector(dot)com> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | David Fetter <david(at)fetter(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Early WIP/PoC for inlining CTEs |
| Date: | 2018-07-25 18:36:45 |
| Message-ID: | 20180725183644.GO5695@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jul 25, 2018 at 05:08:43PM +0100, Andrew Gierth wrote:
> Nico> It is possible to add a keyword for this purpose in the WITH syntax:
>
> Nico> WITH VIEW (...) AS a_view
>
> The existing (and standard) syntax is WITH ctename AS (query).
Oy, I flubbed that up.
> Syntaxes that have been suggested for explicitly controlling the
> materialization are along the lines of:
>
> WITH ctename AS [[NOT] MATERIALIZED] (query)
>
> (MATERIALIZED is already an un-reserved keyword)
Works for me.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nico Williams | 2018-07-25 18:39:19 | Re: Early WIP/PoC for inlining CTEs |
| Previous Message | Nico Williams | 2018-07-25 18:34:40 | Re: How can we submit code patches that implement our (pending) patents? |