Re: subquery and sub-SELECT

2024-08-03 Thread Tatsuo Ishii
> Tatsuo Ishii writes: >> In our documentations, "subquery", "sub-query", "sub-select" and >> "sub-SELECT" are used. In English, are they interchangeable? > > Pretty nearly. I think "sub-query" can include DML such as > INSERT RETURNING, whereas "sub-select" should only be a SELECT. > (I'm not c

Re: subquery and sub-SELECT

2024-08-03 Thread Tom Lane
Tatsuo Ishii writes: > In our documentations, "subquery", "sub-query", "sub-select" and > "sub-SELECT" are used. In English, are they interchangeable? Pretty nearly. I think "sub-query" can include DML such as INSERT RETURNING, whereas "sub-select" should only be a SELECT. (I'm not claiming that