Timeline for Many-to-many: select an entity by matching relationship
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 22 at 22:47 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
deleted 11 characters in body
|
| Jul 22 at 22:46 | comment | added | Erwin Brandstetter |
@Александр: Note the fixed NOT EXISTS for the 2nd query. And the added explanation.
|
|
| Jul 22 at 22:30 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
fix 2nd NOT EXISTS; add instructions for indexes and lperformance; inks
|
| Jul 22 at 7:34 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
add to 2nd query
|
| Jul 22 at 6:41 | comment | added | Александр | Thanks for the answer. The second query, unfortunately, will not help in any way in the case where there are extra relations besides those in the array. m.name = ANY($1) will limit COUNT to the length of the array. | |
| Jul 22 at 5:50 | vote | accept | Александр | ||
| Jul 22 at 1:07 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
add generic query
|
| Jul 21 at 23:55 | history | answered | Erwin Brandstetter | CC BY-SA 4.0 |