Timeline for Join multiple tables without duplicated results and without UNION in PostgreSQL
Current License: CC BY-SA 4.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 29 at 7:08 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 10 at 20:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 9, 2023 at 15:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 9, 2023 at 4:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 9, 2023 at 4:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 8, 2022 at 11:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 23, 2022 at 20:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 21, 2022 at 1:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 16, 2021 at 2:01 | comment | added | Erwin Brandstetter | The question needs refinement. Exact table definitions and requirements. Cardinalities for columns involved in the join. And always your version of Postgres. Should go without saying. | |
| Apr 16, 2021 at 2:00 | answer | added | Erwin Brandstetter | timeline score: 0 | |
| Apr 15, 2021 at 23:40 | answer | added | Charlieface | timeline score: 0 | |
| Apr 15, 2021 at 15:56 | review | First posts | |||
| Apr 15, 2021 at 16:42 | |||||
| Apr 15, 2021 at 15:44 | comment | added | nbk | Union all is the fastest way to cmbine two resultsets, as it doesn't check for doubles | |
| Apr 15, 2021 at 15:37 | comment | added | Laurenz Albe |
I am not so certain that a UNION ALL will be slower than some other complicated SQL statement (at least it would be complicated for me).
|
|
| Apr 15, 2021 at 15:35 | comment | added | Andrei Vinogradov | If there are 2+ joins it will be 2+ SELECT statements. I wonder, if I can achieve that is one SELECT statement which is definitely could be faster than executing 2+ different select statements. | |
| Apr 15, 2021 at 15:32 | comment | added | Laurenz Albe |
What's wrong with UNION ALL?
|
|
| Apr 15, 2021 at 15:26 | history | asked | Andrei Vinogradov | CC BY-SA 4.0 |