Timeline for Make IN clause behave like AND clause
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 7, 2018 at 3:31 | comment | added | Evan Carroll | For what it's worth, I would go with @Craig's answer dba.stackexchange.com/a/74684/2639 | |
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Aug 27, 2014 at 14:40 | history | post merged (destination) | |||
| Aug 23, 2014 at 10:43 | history | tweeted | twitter.com/#!/StackDBAs/status/503130301938561024 | ||
| Aug 22, 2014 at 23:22 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
typos, clarify
|
| Aug 22, 2014 at 23:18 | comment | added | Erwin Brandstetter |
You did not specify whether (post_id, category_id) is unique in post_categories. Daniel assumes as much for his query. Here is a fiddle with all three queries provided so far: sqlfiddle.com/#!15/6f12f/1
|
|
| Aug 22, 2014 at 22:54 | history | edited | Erwin Brandstetter |
edited tags
|
|
| Aug 22, 2014 at 22:34 | answer | added | Erwin Brandstetter | timeline score: 4 | |
| Aug 22, 2014 at 15:32 | answer | added | Craig Ringer | timeline score: 5 | |
| S Aug 22, 2014 at 9:19 | history | suggested | Daniel Hutmacher |
Retagged: postgresql
|
|
| Aug 22, 2014 at 9:19 | vote | accept | Dima Knivets | ||
| Aug 22, 2014 at 9:10 | review | Suggested edits | |||
| S Aug 22, 2014 at 9:19 | |||||
| Aug 22, 2014 at 9:06 | answer | added | Daniel Hutmacher | timeline score: 3 | |
| Aug 22, 2014 at 9:01 | review | First posts | |||
| Aug 22, 2014 at 9:22 | |||||
| Aug 22, 2014 at 8:56 | history | asked | Dima Knivets | CC BY-SA 3.0 | |
| Aug 21, 2014 at 10:47 | answer | added | Milind | timeline score: 3 |