Re: subquery and sub-SELECT - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: subquery and sub-SELECT
Date
Msg-id 20240804.113009.130888580400999969.ishii@postgresql.org
Whole thread Raw
In response to Re: subquery and sub-SELECT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Tatsuo Ishii <ishii@postgresql.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: subquery and sub-SELECT
Next
From: Robert Treat
Date:
Subject: Re: PG 17 and GUC variables