Currently, I have 1 table consisting of id and otherIds I want to calculate the sum of otherIds present in database. id: 1, otherIds: {1,2,3,4,5} id: 2, otherIds: {3,4,5} id: 3, otherIds: {9,2,1} id: 4, otherIds: {} Desired result: 11…
I'm practicing for my upcoming SQL interview using questions from bigtechinterviews.com and am currently stuck on my solution (See my solution below). Prompt: Write a query to find active users on the Free plan to contact them 1 day before…
I know, it sounds really wierd, but it's true. I was sitting and making an API on node.js, but when I began to test it, I was surprised to find out that nearly in beginning of query treatment when the…
I got strange behavior from dblink_connect. I run my postgresql's servers using docker, mapped 5432 to localhost:5433. When I am connecting to it using psql everything is fine $ psql 'postgresql://pguser:pgpass@localhost:5433/mt5?sslmode=disable' psql (14.4, server 10.22) But when I connect to…
I have a jsonb column such that: | id | fee | |----------|----------------------------------------| | 1 | "[{"Step": "step1", "Value": "10"}]" | | 2 | "[{"Step": "step1", "Value": "999"}]" | | 3 | [] | And I want to calculate the…
For the purposes of an introductory course in python, Django and Postgresql, I am looking for the best way to retrieve table data and display it in a structured way in an html file with Django and python as a…
So I have a table of 4.7 billion records on which I want to perform a group by count expression in Postgres using PGadmin4. Obviously this is gonna take a lot of time and I want to speed up the…
tl;dr NEW.updated_at := NOW(); is not working, where updated_at stores a timestamptz value. I have this trigger function, where the error seems to happen in the first line. The updated_at field stores a timestamptz value, which NOW() should be, but…
I'm having trouble manipulating certain information in a Select. I've tried a few ways but with no positive result. Select: select cpri.sequential, cpri.id, coalesce(sum(pdr.something), 0) something, ... from cpri inner join cpr on cpr.id = cpri.id left join pdr on…
I'll give an example to better clarify what I want: Suppose I have the following classes in my programming language: Class Person( int id, string name, List<Car> cars ); Class Car( int id, string name, string brand ) I want…