Let's image we have a database table: account id | balance There is only one operation of moving money from one account to another. Like this: START TRANSACTION; UPDATE account SET balance = balance - 100 WHERE account_id = 1;…
please assist with the following. i m trying to run a script that accepts one argument $1. The argument can either be a string or character or an integer. I want to use the argument in there where clause to…
I've installed PostgreSQL: nix-env -iA nixos.postgresql Now when I use psql, I get: psql: error: connection to server on socket "/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket? Must I…
Is there a way to achieve this functionality for integer array? jsonb ?| text[] → boolean Do any of the strings in the text array exist as top-level keys or array elements? '{"a":1, "b":2, "c":3}'::jsonb ?| array['b', 'd'] → t…
I have some tables with properties of Name and Result each. i want to join tables by name similarity but limit the result arrived from each group of similarity into max 2 results. CREATE TABLE data_a( Id serial primary key,…
column name "note" - json type data in one cell of the column is written in the following way :- [ {"text":"bbb","userID":"U001","time":16704,"showInReport":true}, {"text":"bb","userID":"U001","time":167047,"showInReport":true} ] interval note column containing data how to find value of key text which contains 'bb' which…
In one of my projects, I want to execute 2 queries in parallel with pg-promise. I have these queries wrapped inside the transaction as added below. I am also using Promise.all() to make database calls in paralllel. I want to…
How to extract the difference of a specific column of multiple rows with same id? Example table: id prev_val new_val date 1 0 1 2020-01-01 10:00 1 1 2 2020-01-01 11:00 2 0 1 2020-01-01 10:00 2 1 2 2020-01-02…
I am building a backend application using typescript, typeORM and postgres, after generating and running my migrations instead of creating the tables of the entities I wrote, it only creates a single empty table of 3 columns called 'migrations' I…
user enabled_app app_id [email protected] active 2553 [email protected] inactive 2553 [email protected] waiting 2553 [email protected] active 2554 [email protected] active 2555 [email protected] waiting 2555 [email protected] active 2556 I have a above table, and expected output would be email count [email protected] 1 [email protected] 2…