Re: "writable CTEs"

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: "writable CTEs"
Date: 2010-12-29 08:16:29
Message-ID: 4D1AEE5D.6070403@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 29/12/10 03:35, Peter Eisentraut wrote:
> On tis, 2010-12-28 at 00:19 +0000, Peter Geoghegan wrote:
>> It's worth noting that officially (i.e. in the docs), we don't even
>> call CTEs CTEs at any point. We call them WITH queries. I think that
>> that's a mistake because we call them CTEs everywhere else.
> I think "WITH query" or "WITH clause" is more understandable than CTE,
> which to me is a term that has no relationship with anything else.
>
>

Peter's comment certainly resonates with me. When I first heard about
this "CTE" business I had to go to the web to discover that they were
components of the WITH clause - which I was familiar with from my DB2
days...

regards

Mark

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2010-12-29 08:33:24 Re: pg_primary_conninfo
Previous Message Joel Jacobson 2010-12-29 07:27:34 Re: pg_dump --split patch