| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: subquery and sub-SELECT |
| Date: | 2024-08-04 02:30:09 |
| Message-ID: | 20240804.113009.130888580400999969.ishii@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Tatsuo Ishii <ishii(at)postgresql(dot)org> 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 we've been perfectly accurate about
> that distinction.) The dashes definitely don't matter.
That makes sense. Thanks for the explanation!
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2024-08-04 03:29:59 | Re: PG 17 and GUC variables |
| Previous Message | Tom Lane | 2024-08-04 02:22:12 | Re: subquery and sub-SELECT |