Re: SELECT List with/without parentheses

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: Jason Tiller <jason(at)starnull(dot)net>, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: SELECT List with/without parentheses
Date: 2025-09-08 07:30:37
Message-ID: 8baebcbb-bbbc-4c0f-8705-1717ccd94fd4@postgresfriends.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Robert Haas 2025-09-08 15:35:21 Re: Lets prohibit predicting the future in the documentation.
Previous Message David G. Johnston 2025-09-07 05:03:05 Re: CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS