Timeline for Efficient PostgreSQL query syntax for duplicating the result
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 6, 2023 at 19:58 | comment | added | Erwin Brandstetter |
While Postgres allows duplicate identifiers in the outer query level, it's typically instrumental to assign unique column aliases. Like: SELECT my_sum AS eaters1, my_sum AS eaters2, my_sum AS eaters3 FROM ...
|
|
| Dec 6, 2023 at 14:15 | comment | added | Lennart - Slava Ukraini | @jvkloc, SQL is closed in the sense that the result of a select query is a derived table. I.e. you can select from a query just fine. | |
| Dec 6, 2023 at 13:18 | vote | accept | jvkloc | ||
| Dec 6, 2023 at 13:15 | comment | added | jvkloc | This looks better, I didn't know that it's possible to "multiselect" like that. And thanks for the latter example, I'm new to SQL and didn't see that possibility. | |
| Dec 6, 2023 at 12:52 | history | edited | Paul White♦ | CC BY-SA 4.0 |
edited body
|
| Dec 6, 2023 at 12:09 | history | edited | Lennart - Slava Ukraini | CC BY-SA 4.0 |
added 52 characters in body
|
| Dec 6, 2023 at 12:00 | history | edited | Lennart - Slava Ukraini | CC BY-SA 4.0 |
added 14 characters in body
|
| Dec 6, 2023 at 11:53 | history | edited | Lennart - Slava Ukraini | CC BY-SA 4.0 |
added 102 characters in body
|
| Dec 6, 2023 at 11:50 | history | undeleted | Lennart - Slava Ukraini | ||
| Dec 6, 2023 at 11:48 | history | deleted | Lennart - Slava Ukraini | via Vote | |
| Dec 6, 2023 at 11:46 | history | answered | Lennart - Slava Ukraini | CC BY-SA 4.0 |