Postgres Pro
Downloads
Home   >   mailing lists

Re: please give me select sqls examples to distinct these! - Mailing list pgsql-general

From Rob Sargent
Subject Re: please give me select sqls examples to distinct these!
Date
Msg-id 9743c2b4-86b9-944d-ca48-6fa73439d70b@gmail.com
Whole thread Raw
In response to Re: please give me select sqls examples to distinct these!  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: please give me select sqls examples to distinct these!
List pgsql-general
Tree view
On 10/25/22 09:24, David G. Johnston wrote:
On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent <robjsargent@gmail.com> wrote:


2: select * from table join table b on Id = idb 



#2 is probably conceptually correct but in this context should be written as:


Actually, a join is NOT conceptually correct here - the output columns for "SELECT *" will be wrong.

David J.

OK.  TBH I thought this was the JOOQ list! Didn't notice the typedef.  So this is all about exact match "tables".

I suppose my #2 could be framed as
    select a* from table as a join table as b on a.<criteria> = b.<criteria>
to be a functional equivalent of INTERSECT?

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: please give me select sqls examples to distinct these!
Next
From: "David G. Johnston"
Date:
Subject: Re: please give me select sqls examples to distinct these!