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