Request a Demo
Home   >   mailing lists

Re: SELECT List with/without parentheses - Mailing list pgsql-docs

From Vik Fearing
Subject Re: SELECT List with/without parentheses
Date
Msg-id 8baebcbb-bbbc-4c0f-8705-1717ccd94fd4@postgresfriends.org
Whole thread Raw
In response to Re: SELECT List with/without parentheses  ("Jason Tiller" <jason@starnull.net>)
List pgsql-docs
Tree view 
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

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS
Next
From: Robert Haas
Date:
Subject: Re: Lets prohibit predicting the future in the documentation.