I am working on a transaction dataset with one date column & one identifier column. Now retroactively I want to create a boolean column to check whether any particular activity (e.g. marketing campaign) should have been sent for that identifier…
I have mixed types of values in the columns but all of them are json object: one field stored as text in column_a: {'field0': 'value0'} another field as json (list of) in column_b: [{'field1': 'value1'},{'field2','value2'}] depending on emptiness of the…
I have table like next Name tblname_01 tblname_02 tblname_03 CREATE TABLE test ( name varchar(128) ); INSERT INTO test VALUES ('tblname_01'), ('tblname_02'), ('tblname_03'); SELECT * FROM test; I would like to get next output: { "rule-type": "selection", "rule-id": "1001", "rule-name":…
This query never finishes: SELECT * FROM logs WHERE user_id IN (1,2,3,4,5) ORDER BY create_time DESC OFFSET 0 ROWS FETCH FIRST 10 ROWS only But it works fast when I run query for each user: SELECT * FROM logs WHERE…
In postgresql, how to get cumulative count? I wanted to get a cumulative count of customers enrolled between 01-01 and 02-01, 01-01 and 03-01, 01-01 and 04-01 etc., Not sure if we can do for loop like in Python? I…
I have a query select id from tasks where name = $1. The value for $1 is passed from the application and it can be null. As far as I understand, with name = null, the query will not give…
I have a file that I want to copy into a table, the table has three columns, create table item ( name Text, t Time without time zone, status Text); the File looks like this: book, 2022-08-13 13:30:01,out char,2022-08-13 13:35:22,…
Im having this error when trying to connect to the database: [auth][cause]: error: password authentication failed for user "user" But i can connect to pgadmin normaly with the same credentials so I dont undertand whats going on. docker-compose.yaml services: postgres:…
select * from bha b where b.bks similar to 'd{2}[A-Z](d{2})d\1'; The purpose is to regex but bks is in the form 12A56856 12A12812 12A898389 Although I already have this data in my database, the query is still not successful. I…
I use infinite scroll at my site and I have to return two variables. The first one is data like 10 users. The second one is total. Total all users from my whole table. Now my query is this: const…