Re: query, probably needs window functions - Mailing list pgsql-general

From David G. Johnston
Subject Re: query, probably needs window functions
Date
Msg-id CAKFQuwaxjJpoUNtNKzDDg0ujJP9Qr+UL2baug8kuFmd4EPnnng@mail.gmail.com
Whole thread Raw
In response to query, probably needs window functions  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: query, probably needs window functions
List pgsql-general
On Friday, May 22, 2020, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
given, let's say:

create table person (id int not null, name varchar);
create table phone (id int not null, person_id int not null, number varchar);

select person.*, phone.number from person join phone on (person.id = phone.person_id) order by...

How would you get results where only the first row for a person was filled in, with rest of that person's phones showing blanks for those columns? I'm guessing that window functions provide this capability, but I don't know how.


If a left join doesn’t give you the answer you want you should probably provide exact input and output data that you are working with/toward.

David J.

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: query, probably needs window functions
Next
From: "Andrus"
Date:
Subject: Re: Query returns no rows in pg_basebackup cluster