Timeline for Return matches that have at least one message
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 1, 2017 at 4:13 | comment | added | Evan Carroll | @Arya That looks right, but keep in mind you don't want to join on a text type. That's slower. Instead, join on an int preferably, or a bigint if you must. | |
| Nov 1, 2017 at 3:47 | vote | accept | Arya | ||
| Nov 1, 2017 at 3:36 | comment | added | Arya | Looks like I need to create a FK constraint too, since match_pk is no longer being used | |
| Nov 1, 2017 at 3:34 | comment | added | Arya | By the looks of it, I have stopped using match_pk, and using match_id instead. Time to delete the match_pk from my table. I did change the query to this pastebin.com/xEdViAkB and it's returning results. Looks correct to you? | |
| Nov 1, 2017 at 3:29 | comment | added | Arya | I'm going to look into things. I'll get back to you | |
| Nov 1, 2017 at 3:24 | comment | added | Evan Carroll |
@Arya if it returns 0 rows, that's all she wrote. There is no problem in the query. Perhaps own_account isn't set to false, and it's null? Shy of that there isn't much room for error on your part either. Create a test case.
|
|
| Nov 1, 2017 at 3:20 | comment | added | Arya | I tested your query, but it returns 0 rows, I know it should return some as I have matches with others replying | |
| Nov 1, 2017 at 3:20 | comment | added | Arya | I created this years ago when I was not familiar with Postgres, that's why I'm using charvar, I will change them to text soon. I also agree that my referances are also confusing. I did not know about convention back when I created this. | |
| Nov 1, 2017 at 3:12 | history | answered | Evan Carroll | CC BY-SA 3.0 |