Problemsby GlyphTrouble with PostgreSQL query
2 posts from 2 people2d activeSteady, +1 this weekunverified
Posts per day
The posts behind it
How to change the query with a number of records condition in all groups and with the sum for a specific column?
My script:. -- DROP TABLE IF EXISTS test; CREATE TABLE IF NOT EXISTS test ( id smallserial, date_pr date, num smallint, naim text, pr numeric(19,4), txt text, CONSTRAINT test_pkey PRIMARY KEY (id) ) INSERT INTO test (date_pr, num, naim, pr, txt) VALUES ('2025-02-01', 1,...
How can I use a composite IN query with Postgres.js?
I'm using Postgres.js and I want to execute a PostgreSQL query using a composite IN condition like this:. SELECT * FROM table WHERE (col1, col2) IN ((1, 2), (2, 3)); In other words, I want to check multiple (col1, col2) pairs at once.. With postgres.js , I tried the following:....
Companies and products named
About this problem
Evidence
2 posts from 2 people in 1 place, about 1 a week over 37 days. Mostly on Stack Overflow [postgresql].
Frustration Frustration 0 of 3· Seen on Stack Overflow
How it was grouped
Posts about PostgreSQL with no known issue, sharing the word "query". First post Sep 21, 2026, latest Oct 27, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
Other PostgreSQL problems
PostgreSQL users keep filing bugs
Top post: "Postgres row-level security leaks across tenants when using a pooled connection", one of 41 posts from 40 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL upgrades break working setups
12 posts from 11 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL queries run too slowly and are hard to tune
7 posts from 7 people on Reddit, Stack Overflow, GitHub issues.
PostgreSQL error messages are cryptic
6 posts from 6 people on GitHub issues, Stack Overflow.
Trouble with PostgreSQL database
Top post: "Canonicalising unit names from a flat file in a normalised database structure", one of 5 posts from 5 people on GitHub issues, Stack Overflow.
PostgreSQL permissions are confusing and error-prone
5 posts from 5 people on GitHub issues, Hacker News.
PostgreSQL feels slow and laggy
4 posts from 4 people on Mastodon, Reddit, GitHub issues.
PostgreSQL connectors and syncs are fragile
4 posts from 4 people on GitHub issues, Hacker News.
Trouble with PostgreSQL jsonb
Top post: "Should semi-structured product attributes (secondary images, specs) be stored as JSONB or normalized tables?", one of 3 posts from 3 people on Stack Overflow.
Trouble with PostgreSQL empty
Top post: "Execute Workflow deletes saved input mappings when its workflow ID expression resolves to empty", one of 3 posts from 3 people on GitHub issues.
Trouble with PostgreSQL credentials
Top post: "SFTP Credentials: Port field clears value and incorrectly formats large port numbers", one of 3 posts from 3 people on GitHub issues.
Trouble with PostgreSQL table
Top post: "`CREATE TABLE ... AS mysql(..., SETTINGS ...)` and `AS postgresql(..., SETTINGS ...)` do not store the", one of 3 posts from 3 people on GitHub issues, Reddit.
History