Re:How We Went All In on sqlc/pgx for Postgres and Go
by erdemozg on Thursday September 09, 2021 @04:29AM
(#28467524)
Can you provide some resources about the lack of support for joins in sqlc? Because I wasn't able to find in official documentation and actually there's a discussion on github containing queries with join statements: https://github.com/kyleconroy/sqlc/issues/213
[ Parent
| on HN ]
Re:How We Went All In on sqlc/pgx for Postgres and Go
by Foobar8568 on Thursday September 09, 2021 @04:36AM
(#28467572)
Yes, I was about to reply to myself with a link to this issue as I couldn't see anything in official docs unless looking at the github issues.
Re:How We Went All In on sqlc/pgx for Postgres and Go
by erdemozg on Thursday September 09, 2021 @04:42AM
(#28467607)
But it seems like this discussion is about the lack of support for null values in enum types in joins (not joins in general). Am I missing something?
Re:How We Went All In on sqlc/pgx for Postgres and Go
by Foobar8568 on Thursday September 09, 2021 @06:31AM
(#28468207)
I got it wrong because of lack of documentations and examples in the official documentation. So one would be only aware of the feature if they read the issue tracker which is dumb, joining two entities (or more) is like the first thing you want to do with a database.