Jack Christensen
Jack Christensen
It would probably be best to figure this out in two steps. First, how to scan a PostgreSQL array into a Go slice. Then how to scan rows into structs....
It would be nice to enforce all the type requirements, but I'm not sure how to use the new definition. It seems that all the Multirange type implementations would now...
I believe that is a PostgreSQL limitation. I don't think that can work even in psql.
> The query that I mentioned above, i.e., SELECT * FROM emp WHERE (name, code) IN (("emp1", "123"), ("emp2", "456")) works in PostgreSQL. That is a very different query from...
> So isn't it safe to say that it is not PostgresSQL limitation? No. Your Java / Kotlin code is apparently doing some query rewriting. That's why I suggested using...
> So is there any way to have prepared statement with IN clause with multiple columns using pgx/pgtype? You'd have to write the query with the parts separated. e.g. ```sql...
As far as the `IN` goes, the PostgreSQL way of doing this is to instead use `= any`. See https://www.postgresql.org/docs/current/functions-comparisons.html#id-1.5.8.30.16. However, the anonymous composite restriction is a pretty hard constraint...
That seems reasonable, but I don't think it is possible. The `MarshalJSON()` method defined on the pgtype doesn't have access to the struct tags. And a quick look at the...
I haven't seen anything like that before. A few things to try: * Connect directly to the PG server to eliminate PgBouncer as a factor * When you have the...
> Looking at this, would a context cancelled or timeout cause a connection to be disconnected? Yes. > And does it notify the server to disconnect. I ask the latter...