I cloned a project that I want to modify and experiment with, and I have all the necessary credentials. However, I'm encountering issues while following the steps outlined in the ReadMe.md file since I cloned it: Clone the project. Create…
I am using on conflict clause for insert query like this: insert into "public"."tbl" ("id", "col1", "col2") values ($1, $2, $3) on conflict ("id") do update set "id" = $4,"col1" = $5,"col2" = $6 returning "id" and I am getting…
CREATE OR REPLACE FUNCTION wrapperFunction() RETURNS bytea AS $BODY$ BEGIN SELECT function1() || function2(); END; $BODY$ LANGUAGE plpgsql Is there a way to make calls to function1 and function2 parallel? (they are read only, no side effects and independent)
Imagine a table of user messages that looks like this: | ID | MESSAGE | RECIPIENT_ID | ULTIMATE_PARENT_ID | SENT_AT | | 1 | Blah. | 10 | 1 | 2024-09-10T10:10:00 | | 2 | Blah2 | 10 | 2…
I'm a noob in the recursive domain in that I understand the syntax but I'm unable to apply it to my current problem. I'm using Postgre SQL. I have a product_id 'ABC123' that has a parent category 'FG_ACC_CA', which itself…
I have a table with student data which includes their start and withdrawal dates. Not all students have withdrawal dates as they are still enrolled. I am trying to calculate the number of new students per month, withdrawals per month,…
From "Montreal" as the origin point, I'm trying to find the shortest path to go to another city. But I'm having difficulty when a city is looped. demo at db<>fiddle create table flights(id,src,dst,cost)as values (0,'Montreal','NY', 742.94) ,(1,'Montreal','Detroit', 362.47) ,(2,'NY', 'Detroit',…
I have a table zipnames with four columns: id, zipcode, name_fi and name_sv. Both of the name_* columns are nullable. For each possible zipcode, I might have up to four rows: both names present, only name_fi present, only name_sv present,…
I'm revisiting an old question from 16 years ago about PostgreSQL HASH indexes vs B-TREEs. At the time, it seemed like HASH indexes were far less efficient than B-TREEs in terms of both space and time and the consensus was…
I have a table that contains ~ 100.000.000 records. In this table, there's a varchar(30) column that contains the license plates of cars. I'm joining this table with another table that contains the same amount of records. I need to…