Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uvWKr-00Eqc8-Cq for pgsql-docs@arkaria.postgresql.org; Mon, 08 Sep 2025 07:30:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uvWKq-002lnq-EB for pgsql-docs@arkaria.postgresql.org; Mon, 08 Sep 2025 07:30:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uvWKq-002lnf-6P for pgsql-docs@lists.postgresql.org; Mon, 08 Sep 2025 07:30:44 +0000 Received: from relay6-d.mail.gandi.net ([2001:4b98:dc4:8::226]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uvWKo-0017AY-1U for pgsql-docs@lists.postgresql.org; Mon, 08 Sep 2025 07:30:43 +0000 Received: by mail.gandi.net (Postfix) with ESMTPSA id CF08C43252; Mon, 8 Sep 2025 07:30:37 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=postgresfriends.org; s=gm1; t=1757316638; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=ogZkXm4PbuP2oabA+z6QzhPF7zvqjOVIceJvCHxpcog=; b=DXkJvRcIBZhiMD7oSu+ayipmXyRAY1tCjFCilihSxE7gq3Ezco4ZfhHZVUSUolkeRjlvu0 Celw/HsLQ8u/oLfcFDJJQECjXU30xl/kODWbE32i4RT0ner0AiBirEvwETnCXd0gVBJNjx Ikpi+cKV4QRbl9n74chU45DDtH/IiwpmKDqbhk1IAP+K0EBh/KViEmZULg3xpNRvIQ/HJt kFAergK1n0QsCj95nU5MFWwuIb0hRvpuB8Twc3M+PxYHnvIjF6Jchv0mNqAiZhMDti5C9A o+8qGURN5PgheJDTCwn07gJLfEyVPVLo4jJ/wdghO0I4mGYrtsulUFiIl4c6sQ== Message-ID: <8baebcbb-bbbc-4c0f-8705-1717ccd94fd4@postgresfriends.org> Date: Mon, 8 Sep 2025 09:30:37 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: SELECT List with/without parentheses To: Jason Tiller , pgsql-docs@lists.postgresql.org References: <175702516430.356921.959597202664413151@wrigleys.postgresql.org> <1529415.1757107022@sss.pgh.pa.us> <6cc77ca1-54e7-4e8d-a69e-6159fa497cb7@app.fastmail.com> Content-Language: en-US From: Vik Fearing In-Reply-To: <6cc77ca1-54e7-4e8d-a69e-6159fa497cb7@app.fastmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-GND-State: clean X-GND-Score: -100 X-GND-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdduieelgecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfitefpfffkpdcuggftfghnshhusghstghrihgsvgenuceurghilhhouhhtmecufedtudenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurhepkfffgggfuffvfhfhjggtgfesthejredttddvjeenucfhrhhomhepgghikhcuhfgvrghrihhnghcuoehvihhksehpohhsthhgrhgvshhfrhhivghnughsrdhorhhgqeenucggtffrrghtthgvrhhnpeeuffeiudeguddvhefhfedvtdeltddtledttdeuieeiteeggefhjeehhffgieeigfenucfkphepvdgrtddvmeekgedvkeemudduvgdtmedvjedtudemleelsggrmegtlegsieemvgehiehfmegrfeegvgenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpedvrgdtvdemkeegvdekmeduudgvtdemvdejtddumeellegsrgemtgelsgeimegvheeifhemrgefgegvpdhhvghloheplgfkrfggieemvdgrtddvmeekgedvkeemudduvgdtmedvjedtudemleelsggrmegtlegsieemvgehiehfmegrfeegvggnpdhmrghilhhfrhhomhepvhhikhesphhoshhtghhrvghsfhhrihgvnhgushdrohhrghdpnhgspghrtghpthhtohepvddprhgtphhtthhopehjrghsohhnsehsthgrrhhnuhhllhdrnhgvthdprhgtphhtthhopehpghhsqhhlqdguohgtsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-GND-Sasl: vik@postgresfriends.org List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 06/09/2025 02:02, Jason Tiller wrote: > Thanks for your feedback! I'm a SQL newbie and the "implicit row constructor" syntax was an unwelcome surprise. The reason for it is so you can write WHERE (a, b) > (1, 2) and similar. Perhaps WHERE ROW(a, b) > ROW(1, 2) would have been better, perhaps not. -- Vik Fearing