postgres-9.6 Questions

Postgres parameterized query with INSERT ON CONFLICT and geometry not working in PHP

December 31, 2023
developer981
2 Answers

I do not know why this isn't working. Is it something about using parameters in the query twice? Using PHP 7.4.33, Postgres PostgreSQL 9.6.22. Error is: Warning: pg_query_params(): Query failed: ERROR: inconsistent types deduced for parameter $2 LINE 11: ,…

VIEW QUESTION

Postgresql – Filtering by JSON type field with Postgres and SQLAlchemy

December 8, 2023
Duncan
2 Answers

I have a table test_table: Column | Type | ------------+------------------------+ id | integer | attributes | json | With content: id | attributes ----+---------------------------- 1 | {"a": 1, "b": ["b1","b2"]} 2 | {"a": 2, "b": ["b3"]} 3 | {"a": 3}…

VIEW QUESTION