Timeline for What am I missing in my crosstab query here?
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 27, 2022 at 9:29 | history | became hot network question | |||
| Sep 27, 2022 at 9:08 | vote | accept | arilwan | ||
| Sep 27, 2022 at 9:00 | history | tweeted | twitter.com/StackDBAs/status/1574685289037156355 | ||
| Sep 27, 2022 at 7:54 | answer | added | user1822 | timeline score: 4 | |
| Sep 27, 2022 at 7:43 | history | edited | arilwan | CC BY-SA 4.0 |
added 304 characters in body
|
| Sep 27, 2022 at 7:38 | comment | added | arilwan | @a_horse_with_no_name I edited my question to clear the doubt. | |
| Sep 27, 2022 at 7:37 | history | edited | arilwan | CC BY-SA 4.0 |
added 304 characters in body
|
| Sep 27, 2022 at 7:21 | comment | added | user1822 |
You have two responses for question_id = 36. If one would be one and the other two (instead of both being 0 in your sample data) what should the output for bus be then? A comma separated list of the responses, e.g. one,two?
|
|
| Sep 27, 2022 at 7:14 | history | edited | arilwan |
edited tags
|
|
| Sep 27, 2022 at 7:14 | comment | added | arilwan | @a_horse_with_no_name OK, removing the tag. But the question is generally about the building sql to return the needed result set. | |
| Sep 27, 2022 at 7:13 | comment | added | arilwan | @jjanes Although not used here, the seconds represent the response submission time (unix). | |
| Sep 27, 2022 at 5:54 | comment | added | user1822 | Unrelated to your problem, but: Postgres 9.6 is no longer supported you should plan an upgrade as soon as possible. | |
| Sep 27, 2022 at 5:54 | history | edited | user1822 |
edited tags
|
|
| Sep 27, 2022 at 2:02 | comment | added | jjanes | What is supposed to be done with all of those different seconds? | |
| Sep 27, 2022 at 0:20 | history | asked | arilwan | CC BY-SA 4.0 |